| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | <pgsql-docs(at)postgresql(dot)org> |
| Subject: | Re: Wrong manual info? |
| Date: | 2001-10-09 18:42:35 |
| Message-ID: | Pine.LNX.4.30.0110092000340.672-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
Christopher Kings-Lynne writes:
> Another thing, why is there a funtional form of 'now' called now(), but not
> a functional form of 'today' called today()? (7.1.3)
Most of these are legacy and/or compatibility and/or convenience things.
'today' is now called CURRENT_DATE and 'now' is called CURRENT_TIMESTAMP,
plus or minus a type cast. The now() function is also there for ODBC
compliance. To make things worse, ODBC also adds (or should add)
CURDATE() and CURRENT_DATE() and other such redundant things.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter
| From | Date | Subject | |
|---|---|---|---|
| Next Message | leo | 2001-10-11 09:46:26 | Re: http://www.ca.postgresql.org/docs/tutorial/tutorial.htm |
| Previous Message | Christopher Kings-Lynne | 2001-10-09 01:26:17 | Re: Wrong manual info? |