| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-01-22 17:13:33 | Re: TIMESTAMP comparison problem |
| Previous Message | Michael Glaesemann | 2008-01-22 12:42:20 | Re: TIMESTAMP comparison problem |