Re: Interval unit format bug

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gary Clarke <gary@onedb.online>
Cc: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2026-04-30T14:04:58Z
Lists: pgsql-bugs
Gary Clarke <gary@onedb.online> writes:
> Even if I set to verbose, Postgres outputs a very strange abbreviation for interval unit months that nobody else uses or would expect.

[ shrug... ]  This is documented:

https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-INTERVAL-OUTPUT

If we were to change it now, decades after the fact, what we'd mostly
accomplish is to break applications.

			regards, tom lane