Re: BUG #16169: Default time output for 24:00 is 00:00
Tom Lane <[email protected]> Tue, 17 Dec 2019 13:18:00 -0500
| Newsgroups | gmane.comp.db.postgresql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Alvaro Herrera <[email protected]> writes: > 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. Another theory is that the webpage is passing the output through some type-aware reformatting ... that seems pretty weird though. regards, tom lane