Received: from bleys.tpgi.com.au (bleys.tpgi.com.au [203.12.160.38]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8B11P775250 for ; Mon, 10 Sep 2001 21:01:26 -0400 (EDT) (envelope-from quals@tpg.com.au) Received: (from smtpd@localhost) by bleys.tpgi.com.au (8.11.2/8.11.2) id f8B11Mq20047 for ; Tue, 11 Sep 2001 11:01:22 +1000 Received: from bri2-56k-129.tpgi.com.au(203.29.144.129), claiming to be "hnjack" via SMTP by bleys.tpgi.com.au, id smtpdFIPwvY; Tue Sep 11 11:01:20 2001 Message-ID: <000f01c13a5c$ade8c540$2400a8c0@hnjack> From: "datactrl" To: Subject: array variable in pl/pgsql Date: Tue, 11 Sep 2001 10:57:05 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200109/83 X-Sequence-Number: 4731 Hi all Is there any sample to show how to use array variable in PL/pgsql? How do I get an array from a table and do a loop to manipulate every element in that array? jack