Re: arrays as pgsql function parameters

Josh Berkus wrote:
> 
> Joseph,
> 
> > actually i already have and basically the function statments start as
> >  create function test(_int4) returns integer
> > when i tried to execute the function
> >  select test('{1,2,3,4}');
> > it didnt spew out errors but it didnt output results either
> 
> How about posting a full function definition?
> 
> We're not telepathic.
> 
> -Josh

here is the sample function that i got from the internet.
hope you can send me a sample function

create function foo(_int4) returns int2 as'   declare   a _int4 alias for $1;   i int:=1;   begin   while a[i] loop
i:=i+1;  end loop;   return i-1;   end;   ' language 'plpgsql';