| From: | Frank Heikens <frank(at)elevarq(dot)com> |
|---|---|
| To: | Gary Clarke <gary(at)onedb(dot)online> |
| Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Interval unit format bug |
| Date: | 2026-04-30 14:03:14 |
| Message-ID: | 9FA4834C-D873-4216-BBD3-BCDCD5D10BF2@elevarq.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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(at)onedb(dot)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
gary(at)onedb(dot)online<mailto:gary(at)onedb(dot)online>
+351 9688 20662
+44 746 223 4269
www.onedb.online<http://www.onedb.online/>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2026-04-30 14:03:34 | Re: Interval unit format bug |
| Previous Message | Andrey Borodin | 2026-04-30 12:03:29 | Re: BUG #19458: OOM killer in jsonb_path_exists_opr (@?) with malformed JSONPath containing non-existent variables |