Re: Interval unit format bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Interval unit format bug
Date
Msg-id 742270.1777557898@sss.pgh.pa.us
Whole thread
In response to Interval unit format bug  (Gary Clarke <gary@onedb.online>)
List 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
orwould 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



pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Interval unit format bug
Next
From: Ayush Tiwari
Date:
Subject: Re: to_date()/to_timestamp() silently accept month=0 and day=0