Postgres Pro
Downloads
Home   >   mailing lists

Thread: Function with variable number of arguments

Function with variable number of arguments

From
Olivier Thauvin
Date:
Is it possible to have or create a SQL function with variable numbers of
arguments:

FUNC(...) which reply to call FUNC("") or FUNC('', ''), ect...

It seems not :(
Attachment

Re: Function with variable number of arguments

From
"Keith Worthington"
Date:
On Thu, 14 Apr 2005 17:26:53 +0200, Olivier Thauvin wrote
> Is it possible to have or create a SQL function with variable
> numbers of arguments:
>
> FUNC(...) which reply to call FUNC("") or FUNC('', ''), ect...
>
> It seems not :(

Sure.  See function overloading in the documentation.
http://www.postgresql.org/docs/8.0/interactive/xfunc-overload.html

Kind Regards,
Keith