| From: | "David E(dot) Wheeler" <david(at)justatheory(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, Peter Eisentraut <peter(at)eisentraut(dot)org>, jian he <jian(dot)universality(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Document DateStyle effect on jsonpath string() |
| Date: | 2024-09-11 19:20:50 |
| Message-ID: | 6B388D57-0981-47C3-AD08-7338EE57F0E1@justatheory.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sep 11, 2024, at 15:08, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Right. I actually lifted the code from convertJsonbScalar in
> jsonb_util.c.
>
> Here's a more fleshed-out patch with docs and regression test
> fixes. I figured we could shorten the tests a bit now that
> the point is just to verify that datestyle *doesn't* affect it.
Looks good. Although…
Should it use the database-native stringification standard or the jsonpath stringification standard? In the case of the former, output should omit the “T” time separator and simplify the time zone `07:00` to `07`. But if it’s the latter case, then it’s good as is.
Best,
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2024-09-11 19:32:16 | Re: not null constraints, again |
| Previous Message | Lars Kanis | 2024-09-11 19:08:45 | Re: libpq: Process buffered SSL read bytes to support records >8kB on async API |