timestamp precision - Mailing list pgsql-novice

From A Gilmore
Subject timestamp precision
Date
Msg-id 414549FE.9000202@shaw.ca
Whole thread Raw
Responses Re: timestamp precision
Re: create table error
List pgsql-novice
Hello,

Im using the default precision for my timestamps, 6.  Is it safe to
declare this column unique?  Because you can define the level of
precision I assume you could theoretically have a duplicate.  Or does a
precision of 6 give you an accuracy at the point where pgsql could never
do 2 transactions in the given timestamp time span?

I likely could have written this better, I hope its understandable.

Thank you in advance.

A Gilmore

pgsql-novice by date:

Previous
From: Rafael Charnovscki
Date:
Subject: Re: Postgres 8 Windows binary - where to get?
Next
From: Michael Glaesemann
Date:
Subject: Re: timestamp precision