| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jason Earl <jason(dot)earl(at)simplot(dot)com> |
| Cc: | "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>, pgsql-general(at)postgresql(dot)org, Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
| Subject: | Re: Simplicity in time/date functions |
| Date: | 2002-01-03 21:05:05 |
| Message-ID: | 15750.1010091905@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jason Earl <jason(dot)earl(at)simplot(dot)com> writes:
> Try:
> processdata=> SELECT CURRENT_DATE - 28;
> Thomas could probably explain why this is.
Because the SQL92 spec says so.
CURRENT_DATE with empty parens *is* allowed by ODBC, apparently, and
for 7.2 Peter Eisentraut hacked the parser to accept it with or without
empty parens. Thomas was not happy with that, and wants to take it out
again in 7.3, but I'd prefer to see things left as-is. IMHO there's no
real good reason *not* to accept the empty parens, and we'll keep
getting this sort of question if we revert to the hard-line
SQL-spec-and-nothing-but approach.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | wsheldah | 2002-01-03 21:33:35 | Re: force justification of columns |
| Previous Message | Johnson, Shaunn | 2002-01-03 21:03:25 | force justification of columns |