Re: Time as keyword - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: Time as keyword
Date
Msg-id 3C3C6EC8.72C654EA@fourpalms.org
Whole thread Raw
In response to Re: Time as keyword  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
List pgsql-hackers
...
> Imho it would be nice if we could allow "select timestamp(xxx);",
> and this has been the umpteenth request in this regard, and 7.2 is not even
> released yet.

afaicr one of the very sticky areas is the SQL99-specified syntax for
date/time literals:
 timestamp(6) '2001-01-08 04:05:06'

which is difficult to reconcile with a function named timestamp:
 timstamp(something)
                      - Thomas


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: pg_upgrade
Next
From: Daniel Kalchev
Date:
Subject: Re: again on index usage