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!