Re: Timestamp precission question

Поиск
Список
Период
Сортировка
От Vaclav TVRDIK
Тема Re: Timestamp precission question
Дата
Msg-id 4919ED52.8010807@i3.cz
обсуждение исходный текст
Ответ на Re: Timestamp precission question  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Timestamp precission question  (Adriana Alfonzo <adriana.alfonzo@venalum.com.ve>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case)
Следующее
От: Adriana Alfonzo
Дата:
Сообщение: Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case)