Thread: Stored procedures with variable number of args ?

Stored procedures with variable number of args ?

From

"Bruno BAGUETTE"

Date:

01 October 2003, 03:37:23

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

Re: Stored procedures with variable number of args ?

From

Peter Eisentraut

Date:

01 October 2003, 10:26:59

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