From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Niladic functions |
Date: | 1999-03-09 03:58:50 |
Message-ID: | 36E49C7A.115B9732@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> The "Integrated Document" on the web page has the following paragraph
> in the section "CREATE TABLE" in chapter 20.
> In the current release (v6.4), Postgres evaluates all default
> expressions at the time the table is defined. Hence, functions which
> are "non-cacheable" such as CURRENT_TIMESTAMP may not produce the
> desired effect. For the particular case of date/time types, one can
> work around this behavior by using "DEFAULT TEXT 'now'" instead of
> "DEFAULT 'now'" or "DEFAULT CURRENT_TIMESTAMP". This forces Postgres
> to consider the constant a string type and then to convert the value
> to timestamp at runtime.
>
> This appears to be untrue. Is this a change since 6.4 or is there
> some cases where using CURRENT_TIMESTAMP will not do the expected
> thing?
Sorry for being slow, but exactly which of the several assertions in the
above paragraph are not true? Just the DEFAULT CURRENT_TIMESTAMP
behavior?
> Also, the title of the document (The PostgreSQL Development Team)
> seems to be incorrect.
My browser shows that as the second line, just under the title
"PostgreSQL", as I intended. What browser are you using?
- Tom
From | Date | Subject | |
---|---|---|---|
Next Message | Horak Daniel | 1999-03-09 08:29:36 | dynamic loading on NT works! |
Previous Message | Bruce Momjian | 1999-03-09 03:48:37 | Re: [HACKERS] Developers globe |