Re: Variadic polymorpic functions

2010/1/22 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> writes:
>> 2010/1/22 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>>> Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> writes:
>>>> So there's no way to have a function accepting a VARIADIC ANY. Right?
>>>
>>> Not in PL functions.  You can do it in C if you're desperate (but you
>>> then have to deal with each argument individually --- they're not formed
>>> into an array).
>
>> How would then be declared such a function with the body written in C?
>
> I think "variadic any" is exactly it, but too lazy to go look.

I fear there's no way!

tmp1=# CREATE FUNCTION q( fmt text, variadic args any )
RETURNS void
LANGUAGE plpgsql
AS $function$
declare
begin
end;
$function$;

ERROR: syntax error at or near "any"
LINE 1: CREATE FUNCTION q( fmt text, variadic args any )
^
tmp1=# CREATE FUNCTION q( fmt text, variadic args anyelement )
RETURNS void
LANGUAGE plpgsql
AS $function$
declare
begin
end;
$function$;

ERROR: VARIADIC parameter must be an array
#

--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS