Received: from mail.ngi.de ([195.243.0.227]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA85443 for ; Mon, 27 Dec 1999 08:21:54 -0500 (EST) (envelope-from michael@fam-meskes.de) Received: from p3E9D3E0E.dip0.t-ipconnect.de (root@p3E9D3E0E.dip0.t-ipconnect.de [62.157.62.14]) by mail.ngi.de (8.9.3/8.9.3) with ESMTP id OAA82542; Mon, 27 Dec 1999 14:22:43 +0100 (CET) (envelope-from michael@fam-meskes.de) Received: (from michael@localhost) by p3E9D3E0E.dip0.t-ipconnect.de (8.9.3/8.9.3/Debian 8.9.3-6) id OAA01114; Mon, 27 Dec 1999 14:23:31 +0100 Date: Mon, 27 Dec 1999 14:23:30 +0100 From: Michael Meskes To: "S.F. Lee" Cc: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] manipulate array wiht ecpg Message-ID: <19991227142330.A949@fam-meskes.de> Mail-Followup-To: "S.F. Lee" , pgsql-interfaces@postgreSQL.org References: <19991227095139.20990.qmail@web214.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0i In-Reply-To: <19991227095139.20990.qmail@web214.mail.yahoo.com>; from sflee_tw@yahoo.com on Mon, Dec 27, 1999 at 01:51:39AM -0800 On Mon, Dec 27, 1999 at 01:51:39AM -0800, S.F. Lee wrote: > I am using ecpg to manipulate the whole row in a > table,and I have a problem in array, can anybody give > me a hint or a small test program to process array? Unfortunately this is a known bug in ecpg. It's listed on the TODO list. However, I have no idea so far how to fix it. The only way you can insert an array is by listing its members. That is you have to create your insert statement via sprintf for instance and use exec sql execute immediate. Sorry. I will fix it as soon as I find a solution. The problem is that ecpg also allows inserting the whole array as single integers by only listing the array. Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael@Fam-Meskes.De | Use PostgreSQL!