Re: INTERVAL output format for iso_8601 is without dashes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Benjamin Kröger <benjamin(dot)kroeger(at)gmail(dot)com>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: INTERVAL output format for iso_8601 is without dashes
Date: 2026-03-16 13:44:23
Message-ID: 2415177.1773668663@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

=?UTF-8?Q?Benjamin_Kr=C3=B6ger?= <benjamin(dot)kroeger(at)gmail(dot)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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2026-03-18 02:37:09 pg_stat_statements does not require shared_preload_libraries to be modified
Previous Message Benjamin Kröger 2026-03-16 11:39:32 Re: INTERVAL output format for iso_8601 is without dashes