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