Re: values from now() in the same transaction

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: values from now() in the same transaction
Дата
Msg-id 45D64F75.3060106@cox.net
обсуждение исходный текст
Ответ на Re: values from now() in the same transaction  (Chris Browne <cbbrowne@acm.org>)
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 02/16/07 17:25, Chris Browne wrote:
> zelvlad@yahoo.com (Vladimir Zelinski) writes:
>> I tried function now(),current_timestamp() but all of
>> them behave similar.
>>
>> I don't believe that it's bug, probably it's a feature
>> of the postgreSql database.
>
> Indeed, that is intentional.  CURRENT_TIMESTAMP and NOW() return the

Ooooh, is that Standard Behavior?

Is there a standard definition for CURRENT_TIMESTAMP?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFF1k91S9HxQb37XmcRAqFsAKCMI+xzFxig2XMDPcsWcRMfToOJ/QCffWwO
iLBhZIc3jGp2VWwVSxW7hRQ=
=RTIl
-----END PGP SIGNATURE-----

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

Предыдущее
От: Jerry LeVan
Дата:
Сообщение: Synchronize tables question....
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: user input during runtime