Request a Demo
Home   >   mailing lists

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

From Frank Heikens
Subject Re: Interval unit format bug
Date
Msg-id 9FA4834C-D873-4216-BBD3-BCDCD5D10BF2@elevarq.com
Whole thread
In response to Interval unit format bug  (Gary Clarke <gary@onedb.online>)
List pgsql-bugs
Tree view
There is something about the presentation in the documentation: https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-INTERVAL-OUTPUT

What would you expect, and how would this be different from the documented output?


Best regards,

Frank


Ps. Drivers like the JDBC driver can also change the format


On Apr 29, 2026, at 5:00 AM, Gary Clarke <gary@onedb.online> wrote:

Hello
 
Applies to all versions and operating systems
 
Even if I set to verbose, Postgres outputs a very strange abbreviation for interval unit months that nobody else uses or would expect.
 
<image001.png>
 
 
Best Regards
 
Gary
 
 
 
<image002.jpg>
Gary Clarke
Onedb CEO
+351 9688 20662
+44 746 223 4269

pgsql-bugs by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: BUG #19458: OOM killer in jsonb_path_exists_opr (@?) with malformed JSONPath containing non-existent variables
Next
From: "David G. Johnston"
Date:
Subject: Re: Interval unit format bug