Re: Timestamp precission question - Mailing list pgsql-general

From Adriana Alfonzo
Subject Re: Timestamp precission question
Date
Msg-id 4919E36C.2000706@venalum.com.ve
Whole thread Raw
In response to Re: Timestamp precission question  (Vaclav TVRDIK <tvrdik@i3.cz>)
List pgsql-general
Por favor no quiero seguir recibiendo mensajes

Vaclav TVRDIK escribió:
> 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
>
>

Aviso Legal  Este mensaje puede contener informacion de interes solo para CVG Venalum. Solo esta permitida su copia,
distribuciono uso a personas autorizadas. Si recibio este corre por error, por favor destruyalo. Eventualmentew los
correoselectonicos pueden ser alterados. Al respecto, CVG Venalum no se hace responsable por los errores que pudieran
afectaral mensaje original. 

Attachment

pgsql-general by date:

Previous
From: Adriana Alfonzo
Date:
Subject: Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case)
Next
From: "Andrus"
Date:
Subject: Avoiding seq scan over 3.2 millions rows