Skip to content

Commit c58071a

Browse files
committed
Change ANSI to ISO standard:
< * Add ANSI INTERVAL handling > * Add ISo INTERVAL handling < o Interpret syntax that isn't uniquely ANSI or PG, like '1:30' or < '1' as ANSI syntax, e.g. interpret '1:30' MINUTE TO SECOND as > o Interpret syntax that isn't uniquely ISO or PG, like '1:30' or > '1' as ISO syntax, e.g. interpret '1:30' MINUTE TO SECOND as 649c649 < * Add pre-parsing phase that converts non-ANSI syntax to supported > * Add pre-parsing phase that converts non-ISO syntax to supported
1 parent 50ce8ab commit c58071a

File tree

1 file changed

+5
-5
lines changed

1 file changed

+5
-5
lines changed

doc/TODO

Lines changed: 5 additions & 5 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 23 17:57:00 EST 2005
5+
Last updated: Wed Mar 23 21:11:00 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,12 +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 ANSI INTERVAL handling
184+
* Add ISo INTERVAL handling
185185
o Add support for day-time syntax, INTERVAL '1 2:03:04'
186186
DAY TO SECOND
187187
o Add support for year-month syntax, INTERVAL '50-6' YEAR TO MONTH
188-
o Interpret syntax that isn't uniquely ANSI or PG, like '1:30' or
189-
'1' as ANSI syntax, e.g. interpret '1:30' MINUTE TO SECOND as
188+
o Interpret syntax that isn't uniquely ISO or PG, like '1:30' or
189+
'1' as ISO syntax, e.g. interpret '1:30' MINUTE TO SECOND as
190190
'1 minute 30 seconds'
191191
o Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS
192192
INTERVAL MONTH), and this should return '12 months'
@@ -646,7 +646,7 @@ Exotic Features
646646

647647
* Add SQL99 WITH clause to SELECT
648648
* Add SQL99 WITH RECURSIVE to SELECT
649-
* Add pre-parsing phase that converts non-ANSI syntax to supported
649+
* Add pre-parsing phase that converts non-ISO syntax to supported
650650
syntax
651651

652652
This could allow SQL written for other databases to run without

0 commit comments

Comments
 (0)