Request a Demo
Home   >   mailing lists

Re: INTERVAL output format for iso_8601 is without dashes - Mailing list pgsql-docs

From Tom Lane
Subject Re: INTERVAL output format for iso_8601 is without dashes
Date
Msg-id 2415177.1773668663@sss.pgh.pa.us
Whole thread Raw
In response to INTERVAL output format for iso_8601 is without dashes  (PG Doc comments form <noreply@postgresql.org>)
List pgsql-docs
Tree view 
=?UTF-8?Q?Benjamin_Kr=C3=B6ger?= <benjamin.kroeger@gmail.com> writes:
> It might help to see the input values that led to the documented output 
> values. If you look e.g. at the mixed interval output for style 
> `postgres_verbose`, all dimensions are signed exactly opposite to the 
> `iso_8601` style.

I believe all the entries in each column of that table represent the
same value.  The reason for the sign difference in postgres_verbose
is that it uses "ago" to indicate an overall sign inversion.

            regards, tom lane

pgsql-docs by date:

Previous
From: Benjamin Kröger
Date:
Subject: Re: INTERVAL output format for iso_8601 is without dashes
Next
From: PG Doc comments form
Date:
Subject: pg_stat_statements does not require shared_preload_libraries to be modified