ODBC and DECIMAL column width

From: "Gene Sokolov" <hook(at)aktrad(dot)ru>
To: <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: ODBC and DECIMAL column width
Date: 1999-12-09 10:06:13
Message-ID: 01cc01bf422d$07003980$0d8cdac3@aktrad.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Hiroki Kataoka 1999-12-09 14:53:25 Re: ODBC and Large Objects, FAQ not working
Previous Message marten 1999-12-09 08:00:09 Re: [INTERFACES] locking on database updates