| From: | "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at> |
|---|---|
| To: | <lockhart(at)fourpalms(dot)org> |
| Cc: | "Dwayne Miller" <dwayne-miller(at)home(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Time as keyword |
| Date: | 2002-01-09 17:07:52 |
| Message-ID: | 46C15C39FEB2C44BA555E356FBCD6FA41EB497@m0114.s-mxs.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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:
But since '2001-01-08 04:05:06' is in single quotes it can't be
a column label, which would be the only other "token?" after a function,
no ?
So it is eighter timestamp(6) followed by ' a single quote, or timestamp
is a function in this context ???
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-01-09 17:19:11 | Re: [HACKERS] --with-tcl build on AIX (and others) fails |
| Previous Message | Tom Lane | 2002-01-09 17:05:45 | Re: --with-tcl build on AIX (and others) fails |