Re: Timestamp precission question - Mailing list pgsql-general

From Vaclav TVRDIK
Subject Re: Timestamp precission question
Date
Msg-id 4919ED52.8010807@i3.cz
Whole thread Raw
In response to Re: Timestamp precission question  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Timestamp precission question  (Adriana Alfonzo <adriana.alfonzo@venalum.com.ve>)
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case)
Next
From: Adriana Alfonzo
Date:
Subject: Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case)