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



Reply via email to