Received: from mta3-rme.xtra.co.nz (mta3-rme.xtra.co.nz [203.96.92.13]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f218xvx13545 for ; Thu, 1 Mar 2001 03:59:57 -0500 (EST) (envelope-from csawtell@xtra.co.nz) Received: from berty ([210.55.87.12]) by mta3-rme.xtra.co.nz with SMTP id <20010301085958.CNIG13537509.mta3-rme.xtra.co.nz@berty>; Thu, 1 Mar 2001 21:59:58 +1300 Content-Type: text/plain; charset="iso-8859-1" From: Christopher Sawtell Organization: At Home To: Jie Liang , Sveinung Haslestad Subject: Re: Array as parameter in plpgSQL functions Date: Thu, 1 Mar 2001 21:41:58 +1300 X-Mailer: KMail [version 1.2] Cc: pgsql-sql@postgresql.org References: In-Reply-To: MIME-Version: 1.0 Message-Id: <01030121415800.31527@berty> Content-Transfer-Encoding: 8bit X-Archive-Number: 200103/4 X-Sequence-Number: 1645 On Thu, 01 Feb 2001 09:47, Jie Liang wrote: > e.g. > > 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'; > > you can call it by: > > select foo('{1232131,12312321,3424234}'); > > you should get 3. In order to get it to work I had to alter it very slightly vis:- chris=# create function array_element_count(_int4) returns integer as ' chris'# declare chris'# a alias for $1; chris'# i integer; chris'# begin chris'# i := 1; chris'# while a[i] loop chris'# i := i+1; chris'# end loop; chris'# return i-1; chris'# end;' language 'plpgsql' with(isstrict,iscachable); CREATE chris=# select array_element_count('{59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,8 7}'); array_element_count --------------------- 29 (1 row) -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN 45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Please refrain from using HTML or WORD attachments in e-mails to me <<--