Postgres Pro
Downloads
Home   >   mailing lists

Re: Is the use of array as PL/PGSQL function arguments ? - Mailing list pgsql-general

From Tom Lane
Subject Re: Is the use of array as PL/PGSQL function arguments ?
Date
Msg-id 29179.1065019967@sss.pgh.pa.us
Whole thread Raw
In response to Is the use of array as PL/PGSQL function arguments ?  (pgsql-ml@baguette.net)
Responses RE : Is the use of array as PL/PGSQL function arguments ?
Why I can't combine %TYPE with [] ?
List pgsql-general
Tree view 
pgsql-ml@baguette.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
anarray 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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: mod_auth_pgsql 2.0.1 don't close the backend connection
Next
From: Dev
Date:
Subject: Views and Rules???