| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | <pgsql-docs(at)postgresql(dot)org> |
| Subject: | Re: Wrong manual info? |
| Date: | 2001-10-09 01:26:17 |
| Message-ID: | ECEHIKNFIMMECLEBJFIGCECKCCAA.chriskl@familyhealth.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
> So TIMESTAMP 'now' does get coerced to a timestamp constant on sight,
> which is what I would expect. I find it rather surprising that the
> unknown-type literal isn't getting coerced during CREATE TABLE too.
> After looking at the code, I see that this is a deliberate hack to
> make the world safe for DEFAULT 'now' --- see catalog/heap.c around line
> 1630 in current sources. However, I think this is an ugly backwards-
> compatibility hack, rather than something the manual should recommend
> as preferred practice. So I think the docs are okay as is.
Fair enough. It just had me quite confused. Maybe it would be worth
putting in a qualifier that says that DEFAULT 'now' is ok?
Another thing, why is there a funtional form of 'now' called now(), but not
a functional form of 'today' called today()? (7.1.3)
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-10-09 18:42:35 | Re: Wrong manual info? |
| Previous Message | Tom Lane | 2001-10-08 14:50:53 | Re: Wrong manual info? |