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

Commita15699b

Browse files
committed
Update ANSI INTERVAL section:
< * Add support for ANSI time INTERVAL syntax, INTERVAL '1 2:03:04' DAY TO SECOND< * Add support for ANSI date INTERVAL syntax, INTERVAL '20-6' YEAR TO MONTH< * Process mixed ANSI/PG INTERVAL syntax, and round value to requested precision<< Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS INTERVAL< MONTH), and this should return '12 months'<< * Interpret INTERVAL '1:30' MINUTE TO SECOND as '1 minute 30 seconds'> * Add ANSI INTERVAL handling> o Add support for day-time syntax, INTERVAL '1 2:03:04'> DAY TO SECOND> o Add support for year-month syntax, INTERVAL '50-6' YEAR TO MONTH> o Process mixed ANSI/PG syntax, and round value to requested> precision or generate an error> o Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS> INTERVAL MONTH), and this should return '12 months'> o Interpret INTERVAL '1:30' MINUTE TO SECOND as '1 minute 30 seconds'> o Support precision, CREATE TABLE foo (a INTERVAL MONTH(3))
1 parent87ba04e commita15699b

File tree

1 file changed

+11
-9
lines changed

1 file changed

+11
-9
lines changed

‎doc/TODO‎

Lines changed: 11 additions & 9 deletions
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:Wed Mar 2312:05:12 EST 2005
5+
Last updated:Wed Mar 2316:09:58 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,14 +181,16 @@ 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 '20-6' YEAR TO MONTH
186-
* Process mixed ANSI/PG INTERVAL syntax, and round value to requested precision
187-
188-
Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS INTERVAL
189-
MONTH), and this should return '12 months'
190-
191-
* Interpret INTERVAL '1:30' MINUTE TO SECOND as '1 minute 30 seconds'
184+
* Add ANSI INTERVAL handling
185+
o Add support for day-time syntax, INTERVAL '1 2:03:04'
186+
DAY TO SECOND
187+
o Add support for year-month syntax, INTERVAL '50-6' YEAR TO MONTH
188+
o Process mixed ANSI/PG syntax, and round value to requested
189+
precision or generate an error
190+
o Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS
191+
INTERVAL MONTH), and this should return '12 months'
192+
o Interpret INTERVAL '1:30' MINUTE TO SECOND as '1 minute 30 seconds'
193+
o Support precision, CREATE TABLE foo (a INTERVAL MONTH(3))
192194

193195
* ARRAYS
194196
o Allow NULLs in arrays

0 commit comments

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