Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] is current_timestamp unique for a transaction? - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: [SQL] is current_timestamp unique for a transaction?
Date
Msg-id 20030216042851.GA2273@wolff.to
Whole thread Raw
In response to is current_timestamp unique for a transaction?  (Alan Gutierrez <ajglist@izzy.net>)
List pgsql-general
Tree view 
On Sat, Feb 15, 2003 at 21:49:34 -0600,
  Alan Gutierrez <ajglist@izzy.net> wrote:
>
> Is current_timestamp(6) garunteed to be unique for each transaction?

No.

If you want guarenteed uniqueness use a sequence.

pgsql-general by date:

Previous
From: Dima Tkach
Date:
Subject: Re: Index not used with IS NULL
Next
From: Tom Lane
Date:
Subject: Re: Index not used with IS NULL