Skip site navigation (1) Skip section navigation (2)

Re: TIMESTAMP comparison problem

From: Stuart Brooks <stuartb(at)cat(dot)co(dot)za>
To: Michael Glaesemann <grzm(at)seespotcode(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: TIMESTAMP comparison problem
Date: 2008-01-22 12:52:13
Message-ID: 4795E6FD.4080107@cat.co.za (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-sql by date

Next:From: Tom LaneDate: 2008-01-22 17:13:33
Subject: Re: TIMESTAMP comparison problem
Previous:From: Michael GlaesemannDate: 2008-01-22 12:42:20
Subject: Re: TIMESTAMP comparison problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group