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

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: folarte(at)peoplecall(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16169: Default time output for 24:00 is 00:00
Date: 2019-12-17 18:14:26
Message-ID: 20191217181426.GA27596@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2019-12-17 18:18:00 Re: BUG #16169: Default time output for 24:00 is 00:00
Previous Message Tomas Vondra 2019-12-17 18:09:57 Re: Memory leak (possibly connected to postgis) leading to server crash