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 f8A7pu707591 for ; Mon, 10 Sep 2001 03:52:04 -0400 (EDT) (envelope-from datactrl@tpg.com.au) Received: (from smtpd@localhost) by bleys.tpgi.com.au (8.11.2/8.11.2) id f8A7pqs03002 for ; Mon, 10 Sep 2001 17:51:52 +1000 Received: from bri2-56k-035.tpgi.com.au(203.29.144.35), claiming to be "hnjack" via SMTP by bleys.tpgi.com.au, id smtpdMHPzlc; Mon Sep 10 17:51:48 2001 Message-ID: <001001c139cc$dbdeae00$2400a8c0@hnjack> From: "jack" To: Subject: array variable in pl/pgsql Date: Mon, 10 Sep 2001 17:47:35 +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/84 X-Sequence-Number: 4742 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