Re: Timestamp precission question

From: Vaclav TVRDIK <tvrdik(at)i3(dot)cz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Timestamp precission question
Date: 2008-11-11 20:38:42
Message-ID: 4919ED52.8010807@i3.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> Hm, I can't replicate that here --- but if you're using floating-point
> timestamps, as is default in 8.3, then a certain amount of
> machine-dependent roundoff fuzziness is not surprising.
>
> regards, tom lane
>
Column is defined in such way:
CREATE_DAT timestamp not null default now(),

but in my opinion the value is already stored in the column and then my
query should return same texts because they do display the same value in
the same format, shouldn't they ?

Thank you
Vaclav Tvrdik

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2008-11-11 20:50:05 Avoiding seq scan over 3.2 millions rows
Previous Message Tom Lane 2008-11-11 20:20:56 Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case)