pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedis current_timestamp unique for a transaction?
4+ messages / 4 participants
[nested] [flat]
* is current_timestamp unique for a transaction?
@ 2003-02-16 03:49 Alan Gutierrez <ajglist@izzy.net>
0 siblings, 3 replies; 4+ messages in thread
From: Alan Gutierrez @ 2003-02-16 03:49 UTC (permalink / raw)
To: pgsql-sql@postgresql.org, PostgreSQL-general <pgsql-general@postgresql.org>
Is current_timestamp(6) garunteed to be unique for each transaction?
--
Alan Gutierrez - ajglist@izzy.net
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: is current_timestamp unique for a transaction?
@ 2003-02-16 04:24 Rod Taylor <rbt@rbt.ca>
parent: Alan Gutierrez <ajglist@izzy.net>
2 siblings, 0 replies; 4+ messages in thread
From: Rod Taylor @ 2003-02-16 04:24 UTC (permalink / raw)
To: Alan Gutierrez <ajglist@izzy.net>; +Cc: pgsql-sql@postgresql.org, PostgreSQL-general <pgsql-general@postgresql.org>
Not guaranteed, but also not likely to be the same value unless you have
high volume.
Use a sequence if you need a unique number.
On Sat, 2003-02-15 at 22:49, Alan Gutierrez wrote:
> Is current_timestamp(6) garunteed to be unique for each transaction?
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
Attachments:
signature.asc (application/pgp-signature, 186B) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] is current_timestamp unique for a transaction?
@ 2003-02-16 04:28 Bruno Wolff III <bruno@wolff.to>
parent: Alan Gutierrez <ajglist@izzy.net>
2 siblings, 0 replies; 4+ messages in thread
From: Bruno Wolff III @ 2003-02-16 04:28 UTC (permalink / raw)
To: Alan Gutierrez <ajglist@izzy.net>; +Cc: pgsql-sql@postgresql.org, PostgreSQL-general <pgsql-general@postgresql.org>
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] is current_timestamp unique for a transaction?
@ 2003-02-17 07:10 Rajesh Kumar Mallah <mallah@trade-india.com>
parent: Alan Gutierrez <ajglist@izzy.net>
2 siblings, 0 replies; 4+ messages in thread
From: Rajesh Kumar Mallah @ 2003-02-17 07:10 UTC (permalink / raw)
To: Alan Gutierrez <ajglist@izzy.net>; pgsql-sql@postgresql.org, PostgreSQL-general <pgsql-general@postgresql.org>
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-02-17 07:10 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-16 03:49 is current_timestamp unique for a transaction? Alan Gutierrez <ajglist@izzy.net>
2003-02-16 04:24 ` Rod Taylor <rbt@rbt.ca>
2003-02-16 04:28 ` Bruno Wolff III <bruno@wolff.to>
2003-02-17 07:10 ` Rajesh Kumar Mallah <mallah@trade-india.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox