Re: [SQL] is current_timestamp unique for a transaction?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Alan Gutierrez <ajglist(at)izzy(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org, PostgreSQL-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: [SQL] is current_timestamp unique for a transaction?
Date: 2003-02-16 04:28:51
Message-ID: 20030216042851.GA2273@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

On Sat, Feb 15, 2003 at 21:49:34 -0600,
Alan Gutierrez <ajglist(at)izzy(dot)net> wrote:
>
> Is current_timestamp(6) garunteed to be unique for each transaction?

No.

If you want guarenteed uniqueness use a sequence.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-16 05:41:04 Re: Index not used with IS NULL
Previous Message Rod Taylor 2003-02-16 04:24:01 Re: is current_timestamp unique for a transaction?

Browse pgsql-sql by date

  From Date Subject
Next Message Dave Gomboc 2003-02-16 12:16:56 select from update from select?
Previous Message Rod Taylor 2003-02-16 04:24:01 Re: is current_timestamp unique for a transaction?