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 f8B0o8769390 for ; Mon, 10 Sep 2001 20:50:09 -0400 (EDT) (envelope-from datactrl@tpg.com.au) Received: (from smtpd@localhost) by bleys.tpgi.com.au (8.11.2/8.11.2) id f8B0o3913431 for ; Tue, 11 Sep 2001 10:50:03 +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 smtpdWNxe84; Tue Sep 11 10:49:57 2001 Message-ID: <097101c13a5b$16e006a0$2400a8c0@hnjack> From: "datactrl" To: Subject: array variable in pl/pgsql Date: Tue, 11 Sep 2001 10:45:42 +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: 4741 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