Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group