Re: BUG #16169: Default time output for 24:00 is 00:00

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #16169: Default time output for 24:00 is 00:00
Дата
Msg-id 20191217181426.GA27596@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: BUG #16169: Default time output for 24:00 is 00:00  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #16169: Default time output for 24:00 is 00:00  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On 2019-Dec-17, Tom Lane wrote:

> However ... when you run it on sqlfiddle, that shows the 't' column as
> 00:00:00 in both cases.  It also shows the fourth column in a format
> that doesn't match any of our intervalstyle formats.

Hm, interesting.  SELECT version() in sqlfiddle's postgres 9.6 says:

PostgreSQL 9.6.6 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit

As I remember, EDB would be visible.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: Memory leak (possibly connected to postgis) leading to servercrash
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16169: Default time output for 24:00 is 00:00