Re: BUG #16169: Default time output for 24:00 is 00:00
Francisco Olarte <[email protected]> Tue, 17 Dec 2019 19:29:21 +0100
| Newsgroups | gmane.comp.db.postgresql.bugs |
|---|---|
| Message-ID | <CA+bJJbzTvsxDL4rnaPOQqT5HnhUJVH48U9N9XioLNsoY=9Bfig@mail.gmail.com> |
On Tue, Dec 17, 2019 at 7:18 PM Tom Lane <[email protected]> wrote: > > 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. I think it is that. http://sqlfiddle.com/#!17/9eecb/43349 == select '24:00'::time::text; returns "24:00:00". Francisco Olarte.