From: Michael Meskes <meskes@postgreSQL.org>
To: S.F. Lee <sflee_tw@yahoo.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] manipulate array wiht ecpg
Date: Mon, 27 Dec 1999 14:23:30 +0100
Message-ID: <19991227142330.A949@fam-meskes.de> (raw)
In-Reply-To: <19991227095139.20990.qmail@web214.mail.yahoo.com>
References: <19991227095139.20990.qmail@web214.mail.yahoo.com>
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!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: meskes@postgreSQL.org, sflee_tw@yahoo.com
Subject: Re: [INTERFACES] manipulate array wiht ecpg
In-Reply-To: <19991227142330.A949@fam-meskes.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox