| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| 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: is current_timestamp unique for a transaction? |
| Date: | 2003-02-16 04:24:01 |
| Message-ID: | 1045369440.12011.54.camel@jester |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-02-16 04:28:51 | Re: [SQL] is current_timestamp unique for a transaction? |
| Previous Message | Dima Tkach | 2003-02-16 04:14:14 | Re: Index not used with IS NULL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-02-16 04:28:51 | Re: [SQL] is current_timestamp unique for a transaction? |
| Previous Message | Alan Gutierrez | 2003-02-16 03:49:34 | is current_timestamp unique for a transaction? |