Re: PG 8.2.7, ECPG & Composite types..

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!