On Sep 13, 2004, at 4:19 PM, A Gilmore wrote:
> Im using the default precision for my timestamps, 6. Is it safe to
> declare this column unique?
The *only* way to ensure uniqueness in a column is to explicitly
declare the column UNIQUE or PRIMARY (which implies UNIQUE NOT NULL
iirc). So if you declare it unique, of course it's safe.
If you are assuming it's unique because of the high precision, well,
you might get lucky, and you might not. (Some might even argue that
it's for all intents and purposes unique). However, if you want to
guarantee uniqueness, declare it UNIQUE.
grzm myrealbox com
In response to
pgsql-novice by date
|Next:||From: Adrian Chew||Date: 2004-09-13 09:38:28|
|Subject: having problem connecting to postgreSQL v7.5.|
|Previous:||From: A Gilmore||Date: 2004-09-13 07:19:26|
|Subject: timestamp precision|