Re: Function with variable number of arguments

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: Olivier Thauvin <olivier(dot)thauvin(at)aerov(dot)jussieu(dot)fr>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Function with variable number of arguments
Date: 2005-04-14 15:39:17
Message-ID: 20050414153826.M62139@narrowpathinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Gerry Jensen 2005-04-14 17:09:05 Re: duplicate rows mystery
Previous Message Olivier Thauvin 2005-04-14 15:26:53 Function with variable number of arguments