Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost whenextracting epoch

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost whenextracting epoch
Дата
Msg-id CA+hUKGKgHUbFNKRhvodn4mVU-oqje+HA7jTg_XrWRo4UGhFoqg@mail.gmail.com
обсуждение исходный текст
Ответ на Since '2001-09-09 01:46:40'::timestamp microseconds are lost whenextracting epoch  (Petr Fedorov <petr.fedorov@phystech.edu>)
Ответы Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения 
On Sat, Nov 30, 2019 at 10:28 PM Petr Fedorov <petr.fedorov@phystech.edu> wrote:
> Obviously, it is due to the fact that extract epoch returns double
> precision which in turn has 15 decimal digits precision.

I guess this deviation from the SQL standard ("exact numeric") made
sense when PostgreSQL used double for timestamps, but would break a
lot of queries if we changed it.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15383: Join Filter cost estimation problem in 10.5
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch