Re: RE : [GENERAL] Is the use of array as PL/PGSQL function arguments

2003-10-09 Thread Bruce Momjian
Added to TODO: o Allow PL/pgSQL to handle %TYPE arrays, e.g. tab.col%TYPE[] --- Bruno BAGUETTE wrote: > > > CREATE OR REPLACE FUNCTION myownfunction(members.id%TYPE[], > > > events.id%TYPE) RETURNS BOOLEAN AS ' >

RE : [GENERAL] Is the use of array as PL/PGSQL function arguments ?

2003-10-02 Thread Bruno BAGUETTE
> > 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. Thanks Tom for the information ! :-) When I create functions with %TYPE, PostgreS