Pavel Stehule <pavel.steh...@gmail.com> writes:
> I didn't explain it well, sorry
> so I have a function foo(variadic "any")
> usual calling like foo(10,20) or foo('a',10) working perfectly. But I
> have a problem with call with VARIADIC keyword
> like foo(VARIADIC ARRAY[10,20]) or foo(VARIADIC ARRAY['a','10']).
> Keyword VARIADIC is allowed, and this a calling doesn't raise any
> error.
What exactly is the use-case for that? You can't expect that an array
will hold the parameter list, since the parameters might not be all the
same type.
> -------- CALL foo(VARIADIC ARRAY[10,20,20]) ---> real
> call foo(10,20,20) -- but it doesn't work now.
I'm not convinced it should work that way. Even if you had convinced me
that this was sensible and had a real use-case, making it work like that
would take a whole bunch of mechanism that doesn't exist.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
