Обсуждение: Function with variable number of arguments

Поиск
Список
Период
Сортировка

Function with variable number of arguments

От
Olivier Thauvin
Дата:
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 :(

Вложения

Re: Function with variable number of arguments

От
"Keith Worthington"
Дата:
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