Re: [HACKERS] Niladic functions
От | Thomas Lockhart |
---|---|
Тема | Re: [HACKERS] Niladic functions |
Дата | |
Msg-id | 378C208C.53BFBDA5@alumni.caltech.edu обсуждение исходный текст |
Ответ на | Re: [HACKERS] Niladic functions (Bruce Momjian <maillist@candle.pha.pa.us>) |
Список | pgsql-hackers |
> Was this addressed? Yes. - Thomas > > 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? > > > > Also, the title of the document (The PostgreSQL Development Team) seems > > to be incorrect. -- Thomas Lockhart lockhart@alumni.caltech.edu South Pasadena, California
В списке pgsql-hackers по дате отправления: