>> 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,
In response to
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2008-01-22 17:13:33|
|Subject: Re: TIMESTAMP comparison problem |
|Previous:||From: Michael Glaesemann||Date: 2008-01-22 12:42:20|
|Subject: Re: TIMESTAMP comparison problem|