From: Michael Meskes <meskes@postgresql.org>
To: List User <pglists@boscorama.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: PG 8.2.7, ECPG & Composite types..
Date: Tue, 13 May 2008 12:07:31 +0200
Message-ID: <20080513100731.GA17238@feivel.credativ.de> (raw)
In-Reply-To: <48190AC8.5000005@boscorama.com>
References: <48190AC8.5000005@boscorama.com>
On Wed, Apr 30, 2008 at 05:11:52PM -0700, List User wrote:
> and in ECPG we have tried various things which either end up with a
> mismatch between column count & value count; or generate an error
> where the values for the embedded composite type have been melded
> together as a text string and telling us that the resulting string
> is an invalid floating point value. Following is an example of the
> latter error:
>
> exec sql insert into items ( name, price.amt, price.iso, stock )
> values ( 'Test Item', 99.2, 1, 101 );
It says this has an invalid floating point?
Could you produce a small test case so we can work on the same example?
Also could you enable logging and post the logs?
Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! 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, pglists@boscorama.com
Subject: Re: PG 8.2.7, ECPG & Composite types..
In-Reply-To: <20080513100731.GA17238@feivel.credativ.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