2010/1/22 Tom Lane <tgl@sss.pgh.pa.us>:
> Vincenzo Romano <vincenzo.romano@notorand.it> writes:
>> 2010/1/22 Tom Lane <tgl@sss.pgh.pa.us>:
>>> Vincenzo Romano <vincenzo.romano@notorand.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