Re: Timestamp precission question

Поиск
Список
Период
Сортировка
От Adriana Alfonzo
Тема Re: Timestamp precission question
Дата
Msg-id 4919E36C.2000706@venalum.com.ve
обсуждение исходный текст
Ответ на Re: Timestamp precission question  (Vaclav TVRDIK <tvrdik@i3.cz>)
Список 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. 

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Adriana Alfonzo
Дата:
Сообщение: Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case)
Следующее
От: "Andrus"
Дата:
Сообщение: Avoiding seq scan over 3.2 millions rows