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

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: Alan Gutierrez <ajglist(at)izzy(dot)net>, 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-17 07:10:57
Message-ID: 200302171240.57479.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

On Sunday 16 February 2003 09:19 am, Alan Gutierrez wrote:
> Is current_timestamp(6) garunteed to be unique for each transaction?

Did you mean to ask if value of current_timestamp(6) remains same within a transaction?

if so answer is yes.

--

Regds
Mallah

----------------------------------------
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-02-17 07:29:07 Re: Creating index does not make any change in query plan.
Previous Message Stephan Szabo 2003-02-17 05:46:49 Re: Index not used with IS NULL

Browse pgsql-sql by date

  From Date Subject
Next Message betty 2003-02-17 10:25:54 Re: trigger after with cursor
Previous Message David Loh 2003-02-17 06:16:44 Trigger that will execute external program