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 по дате отправления:

Предыдущее
От: Brent Peckover
Дата:
Сообщение: PGSQL on NT - connection to database template1 failed.
Следующее
От: Magnus Hagander
Дата:
Сообщение: RE: [HACKERS] Updated TODO list