Variadic functions in plpgsql?

Started by Florian Pflugalmost 22 years ago2 messagesgeneral
Jump to latest
#1Florian Pflug
fgp@phlo.org

Hi

I faintly remember that I once stumbled upon a way to declare variadic
functions (functions that take a variable number of arguments) in plpgsql -
but I just searched the docs and can't find any reference to variadic
functions.

So - please enlighten me - are there variadic functions in plpgsql, or are
there none?

greetings, Florian Pflug

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Florian Pflug (#1)
Re: Variadic functions in plpgsql?

"Florian G. Pflug" <fgp@phlo.org> writes:

I faintly remember that I once stumbled upon a way to declare variadic
functions (functions that take a variable number of arguments) in plpgsql -
but I just searched the docs and can't find any reference to variadic
functions.

Nope. You can sort of kluge around this at the C level (by making
multiple pg_proc entries pointing at the same C function), but there's
no such capability in any PL language.

regards, tom lane