Re: three timestamps/table, use of 'now' in table creation statement - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: three timestamps/table, use of 'now' in table creation statement
Date
Msg-id 20030116144423.GA24326@wolff.to
Whole thread Raw
In response to three timestamps/table, use of 'now' in table creation statement  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
Please don't reply to existing threads to start new ones.

On Thu, Jan 16, 2003 at 01:08:09 -0800,
  Dennis Gearon <gearond@cvc.net> wrote:
> I want to have three timestamps columns in a table:
>
> What I want to happen is that all three columns get set with the 'now'
> value to the nearest second, and they ALL have the exact same value.

You will get the same value if the three times are all obtained within
the same transaction.

pgsql-general by date:

Previous
From: Björn Metzdorf
Date:
Subject: Re: Support for unicode
Next
From: Federico Pedemonte
Date:
Subject: Force index usage on bigint in PL/PGSQL