Re: three timestamps/table, use of 'now' in table creation statement

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Dennis Gearon <gearond(at)cvc(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: three timestamps/table, use of 'now' in table creation statement
Date: 2003-01-16 14:44:23
Message-ID: 20030116144423.GA24326@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)cvc(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Federico Pedemonte 2003-01-16 15:17:04 Force index usage on bigint in PL/PGSQL
Previous Message Björn Metzdorf 2003-01-16 14:06:57 Re: Support for unicode