Re: TIMESTAMP comparison problem - Mailing list pgsql-sql

From Stuart Brooks
Subject Re: TIMESTAMP comparison problem
Date
Msg-id 4795E6FD.4080107@cat.co.za
Whole thread Raw
In response to Re: TIMESTAMP comparison problem  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-sql
>> If I reduce the precision to 3 for the timestamps it appears to work 
>> although it makes me nervous.
>
> With float timestamps, you're fooling yourself if you think those 
> numbers past the decimal are reliable.
>
>> Should I just recompile to use integer datetimes? I would like to 
>> have at least microsecond precision.
>
> Well, you can't get better than microsecond precision with timestamps 
> in Postgres. And the only way you can rely on that level of precision 
> is to compile with --enable-integer-datetimes.
>
> Michael Glaesemann 
I thought that might be the case, thanks for the help,

Stuart


pgsql-sql by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: TIMESTAMP comparison problem
Next
From: Tom Lane
Date:
Subject: Re: TIMESTAMP comparison problem