Received: from Donald.bks (unknown [203.145.133.13]) by postgresql.org (Postfix) with ESMTP id 626C547587E for ; Wed, 6 Mar 2002 09:17:29 -0500 (EST) Received: from Larry.bks (root@Larry.bks [200.2.1.10]) by Donald.bks (8.11.6/8.11.2) with ESMTP id g26EJBR03767 for ; Wed, 6 Mar 2002 19:49:11 +0530 Received: from localhost (bhuvan@localhost) by Larry.bks (8.9.3/8.8.5) with ESMTP id TAA16677 for ; Wed, 6 Mar 2002 19:43:18 +0530 X-Authentication-Warning: Larry.bks: bhuvan owned process doing -bs Date: Wed, 6 Mar 2002 19:43:18 +0530 (IST) From: Bhuvan A X-Sender: bhuvan@Larry To: pgsql-sql@postgresql.org Subject: assigning values to arrays in plpgsql Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200203/64 X-Sequence-Number: 6946 hi all, how can we assign some values to a array variable in a plpgsql function? something like, array_element := {new.field1, new.field2, new.field3}; is it right? then, please correct this! Regards, Bhuvaneswaran.