Quick Links

Re: Is the use of array as PL/PGSQL function arguments ?

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	pgsql-ml(at)baguette(dot)net
Cc:	pgsql-general(at)postgresql(dot)org
Subject:	Re: Is the use of array as PL/PGSQL function arguments ?
Date:	2003-10-01 14:52:47
Message-ID:	29179.1065019967@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

pgsql-ml(at)baguette(dot)net writes:
> Since it's not possible to do a function with a variable number of arguments, I am wondering if it is possible to use an array as an argument in a PL/PGSQL function ?

> CREATE OR REPLACE FUNCTION myownfunction(members.id%TYPE[], events.id%TYPE) RETURNS BOOLEAN AS '

You can certainly use arrays as arguments, but I don't think you can
combine %TYPE with [] like that.

regards, tom lane

In response to

Is the use of array as PL/PGSQL function arguments ? at 2003-10-01 13:27:24 from pgsql-ml

Responses

RE : Is the use of array as PL/PGSQL function arguments ? at 2003-10-02 07:49:35 from Bruno BAGUETTE
Why I can't combine %TYPE with [] ? at 2003-10-16 06:55:19 from Bruno BAGUETTE

Browse pgsql-general by date

	From	Date	Subject
Next Message	Dev	2003-10-01 15:20:56	Views and Rules???
Previous Message	Richard Huxton	2003-10-01 14:40:40	Re: mod_auth_pgsql 2.0.1 don't close the backend connection