| From: | Vik Fearing <vik(at)postgresfriends(dot)org> |
|---|---|
| To: | Chapman Flack <chap(at)anastigmatix(dot)net>, Erik Rijkers <er(at)xs4all(dot)nl> |
| Cc: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: proposal: jsonb_populate_array |
| Date: | 2023-08-15 05:44:36 |
| Message-ID: | b128a2f8-1d42-fd84-d1b9-2ef633c68668@postgresfriends.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 8/14/23 15:47, Chapman Flack wrote:
> On 2023-08-14 09:11, Erik Rijkers wrote:
>> , '$' returning date[]
>
> I certainly like that syntax better.
>
> It's not that the "here's a null to tell you the type I want"
> is terribly unclear, but it seems not to be an idiom I have
> seen a lot of in PostgreSQL before now. Are there other places
> it's currently used that I've overlooked?
It has been used since forever in polymorphic aggregate final functions.
I don't mind it there, but I do not like it in general user-facing
functions.
https://www.postgresql.org/docs/current/sql-createaggregate.html
--
Vik Fearing
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2023-08-15 05:46:24 | Re: Using defines for protocol characters |
| Previous Message | Pavel Stehule | 2023-08-15 05:33:03 | Re: Extract numeric filed in JSONB more effectively |