Stored procedures with variable number of args ?

Started by Bruno BAGUETTEover 22 years ago2 messagesgeneral

pgsql-ml@baguette.net

over 22 years ago

Hello,

Is it possible to make PL/PGSQL stored procedures with a variable number
of args ?

If yes, is it possible to have a sample ?

Thanks you in advance :-)

---------------------------------------
Bruno BAGUETTE - pgsql-ml@baguette.net

Peter Eisentraut

peter_e@gmx.net

over 22 years ago

In reply to: Bruno BAGUETTE (#1)

Re: Stored procedures with variable number of args ?

Bruno BAGUETTE writes:

Is it possible to make PL/PGSQL stored procedures with a variable number
of args ?

Not directly, but you can overload one function name and make versions
that accept 1 .. max arguments.

--
Peter Eisentraut peter_e@gmx.net