On 2024-04-20 14:22 +0200, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/16/datatype-pseudo.html
> Description:
>
> I tryed to implement a safe_cast function with 2 parameters and a return of
> type "any" but it failed. I get a syntax error, if I use "any" as a data
> type, because it is a sql function (similar to array contains) and not a
> data type.
You have to use a double-quoted identifier, i.e. "any" instead of ANY.
But it won't work with PL languages:
=> create function f() returns "any" as 'select 1' language sql;
ERROR: SQL functions cannot return type "any"
You have to code a C function for that.
> And if there is a data type "any" in postgres too, how should it work as
> parameter and wheres the difference to "anyelement"?
"any" is like "anyelement" just without the polymorphic[1] behavior.
So an argument of type "any" does not determine the result type for
"anyarray" as "anyelement" would.
[1] https://www.postgresql.org/docs/current/extend-type-system.html#EXTEND-TYPES-POLYMORPHIC
--
Erik