Interval literal not ANSI compliant

The Postgres INTERVAL literal is not compliant with
the ANSI 2003 SQL Spec.  Here's the Postgres way:

# select INTERVAL '45 DAY';
 interval
----------
 45 days
(1 row)

The spec. says

<interval literal> ::= INTERVAL [ <sign> ] <interval
string> <interval qualifier>

<interval string> ::= <quote> <unquoted interval
string> <quote>

Note specifically that the quotes only enclose the
number, not the interval qualifier.  So Postgres
interval literals should be

# select INTERVAL '45' DAY;
 interval
----------
 00:00:00
(1 row)

Note that Postgres accepts the ANSI form but then
interprets it completely incorrectly.  IMHO this is
much worse than rejecting the ANSI form.  Are there
plans to fix this?  I am using 7.4.3.



_______________________________
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.
http://promotions.yahoo.com/goldrush