Postgres Pro
Downloads
Home   >   mailing lists

Re: Variable number or arguments to a function possible? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Variable number or arguments to a function possible?
Date
Msg-id 25088.1240628978@sss.pgh.pa.us
Whole thread Raw
In response to Variable number or arguments to a function possible?  (Chris Ruprecht <chris@ruprecht.org>)
List pgsql-sql
Tree view 
Chris Ruprecht <chris@ruprecht.org> writes:
> Is it possible to create a function that can take a variable number of  
> arguments?

No, but you can make it take an array and then write something like
myfunc(array[x, y, ...])

8.4 will have some syntactic sugar that looks like variable numbers of
arguments, but it's reducing to the above underneath.
        regards, tom lane

pgsql-sql by date:

Previous
From: "Milen A. Radev"
Date:
Subject: Re: Variable number or arguments to a function possible?
Next
From: "Leif B. Kristensen"
Date:
Subject: Multiple return values and assignment