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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Very strange 'now' behaviour in nested triggers.
Дата
Msg-id 15184.1059411161@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Very strange 'now' behaviour in nested triggers.  (Denis Zaitsev <zzz@anda.ru>)
Ответы Re: Very strange 'now' behaviour in nested triggers.  (Dmitry Tkach <dmitry@openratings.com>)
Список pgsql-sql
Dmitry Tkach <dmitry@openratings.com> writes:
> Why not get rid of 'now' alltogether? Are there any cases when it is 
> actually useful as opposed to now()?

Data entry.  You don't necessarily have the option to invoke a function,
as opposed to just sending a string for the datetime input parser.
(It would be rather difficult for an application to allow this one case
without permitting SQL-injection attacks, I'd think.)
        regards, tom lane


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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Problem using Subselect results
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Problem using Subselect results