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