ODBC and DECIMAL column width - Mailing list pgsql-interfaces

From Gene Sokolov
Subject ODBC and DECIMAL column width
Date
Msg-id 01cc01bf422d$07003980$0d8cdac3@aktrad.ru
Whole thread Raw
Responses Apache+PostgreSQL+PHP3  (Adolfo Diaz <adiaz@vega.inf.cu>)
List pgsql-interfaces
WinNT 4.0, ODBC 6.40.0007.

I have a table

create table test ( a decimal(9,2), b decimal(9,2) );

Now, if I do

select a-b as c from test;

ODBC driver returns 255 for column width. Same thing for any arithmetic
operation between two decimals. Not really a big bug, but definitely
annoying.

Gene Sokolov.




pgsql-interfaces by date:

Previous
From: Peter Mount
Date:
Subject: RE: [INTERFACES] Transaction support in 6.5.3/JDBC
Next
From: "Hiroki Kataoka"
Date:
Subject: Re: ODBC and Large Objects, FAQ not working