Re: Very strange 'now' behaviour in nested triggers.

Поиск
Список
Период
Сортировка
От Dmitry Tkach
Тема Re: Very strange 'now' behaviour in nested triggers.
Дата
Msg-id 3F2552BF.5060100@openratings.com
обсуждение исходный текст
Ответ на Re: Very strange 'now' behaviour in nested triggers.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Tom Lane wrote:

>
>I put up a proposal in pgsql-hackers to change this behavior:
>http://archives.postgresql.org/pgsql-hackers/2003-07/msg00818.php
>If we made that change then the "wrong" way of defining the default
>would fail in an obvious fashion --- the 'now' would get reduced to a
>particular time immediately at CREATE TABLE.  Doubtless this would annoy
>some people, but the "right" way of defining the default isn't really
>any harder, and it would save folks from getting burnt in corner cases,
>like you were.
>
>Any comments?
>
>  
>
Why not get rid of 'now' alltogether? Are there any cases when it is 
actually useful as opposed to now()?

Dima




В списке pgsql-sql по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Problem using Subselect results
Следующее
От: Dmitry Tkach
Дата:
Сообщение: Re: Very strange 'now' behaviour in nested triggers.