View Single Post

   
  #3 (permalink)  
Old 04-19-2008, 07:00 PM
Stuart Brooks
 
Posts: n/a
Default Re: TIMESTAMP comparison problem


>> 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote