Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit3113d38

Browse files
committed
Add INTERVAL items:
> * Add support for ANSI time INTERVAL syntax, INTERVAL '1 2:03:04' DAY TO SECOND> * Add support for ANSI date INTERVAL syntax, INTERVAL '1-2' YEAR TO MONTH> * Process mixed ANSI/PG INTERVAL syntax, and round value to requested precision184a188,189> Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS INTERVAL> MONTH), and this should return '12 months'
1 parente96ab26 commit3113d38

File tree

1 file changed

+6
-1
lines changed

1 file changed

+6
-1
lines changed

‎doc/TODO‎

Lines changed: 6 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
TODO list for PostgreSQL
33
========================
44
Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)
5-
Last updated:Tue Mar22 21:50:58 EST 2005
5+
Last updated:Wed Mar23 00:42:36 EST 2005
66

77
The most recent version of this document can be viewed at the PostgreSQL web
88
site, http://www.PostgreSQL.org.
@@ -181,7 +181,12 @@ Data Types
181181
zero the bits
182182
* Prevent INET cast to CIDR from droping netmask, SELECT '1.1.1.1'::inet::cidr
183183
* Add 'tid != tid ' operator for use in corruption recovery
184+
* Add support for ANSI time INTERVAL syntax, INTERVAL '1 2:03:04' DAY TO SECOND
185+
* Add support for ANSI date INTERVAL syntax, INTERVAL '1-2' YEAR TO MONTH
186+
* Process mixed ANSI/PG INTERVAL syntax, and round value to requested precision
184187

188+
Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS INTERVAL
189+
MONTH), and this should return '12 months'
185190

186191
* ARRAYS
187192
o Allow NULLs in arrays

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp