Re: [GENERAL] Array as parameter for stored procedure

2008-07-09 Thread Pavel Stehule
Hello a) create or replace function iterate(a int[]) returns void as $$ begin for i in array_lower(a,1)..arry_upper(a,1) loop raise notice '%', a[i]; end loop; end; $$ language plpgsql strict; look to: http://www.pgsql.cz/index.php/PL/pgSQL_%28en%29 or http://www.postgresql.org/docs/8.3/i

[GENERAL] Array as parameter for stored procedure

2008-07-09 Thread Hendra
Hi, I'm learning some 3-tier concept here and very interested with postgresql stored-procedure But since I 'm the type who learn from example, I'm having some difficulties here I want to know how postgresql use array as parameter for stored procedure, I imagine a case when we want to save selli