| From: | Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: text -> time cast problem |
| Date: | 2001-12-10 05:03:07 |
| Message-ID: | 3C14420B.FDAA9D4@fourpalms.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
...
> Is there anything wrong with any of these behaviours, and has any of it been
> changed for 7.2? I kind think that the quoted CURRENT_TIMESTAMP should work
> just like the unquoted...
No, it is pretty much the same as before. Quoted 'current_timestamp' has
nothing to do with the SQL9x standard, while unquoted CURRENT_TIMESTAMP
does. For 7.2, we are dropping the somewhat interesting 'current' value,
which was evaluated at the time a math operation was performed, at which
time it became equivalent to 'now'.
- Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2001-12-10 07:38:57 | Re: Bug #533: BLOB (lo type) objects could not be restored |
| Previous Message | Thomas Lockhart | 2001-12-10 04:59:07 | Minor updates for date/time committed |