Received: from ns1.aktrad.ru (ns1.aktrad.ru [195.218.140.4])
	by hub.org (8.9.3/8.9.3) with ESMTP id FAA89711
	for <pgsql-interfaces@postgreSQL.org>;
	Thu, 9 Dec 1999 05:06:50 -0500 (EST) (envelope-from hook@aktrad.ru)
Received: from sloth (sloth.aktrad.ru [195.218.140.13])
	by ns1.aktrad.ru (8.9.3/8.9.3) with SMTP id NAA52165
	for <pgsql-interfaces@postgreSQL.org>;
	Thu, 9 Dec 1999 13:06:09 +0300 (MSK)
Message-ID: <01cc01bf422d$07003980$0d8cdac3@aktrad.ru>
From: "Gene Sokolov" <hook@aktrad.ru>
To: <pgsql-interfaces@postgreSQL.org>
Subject: ODBC and DECIMAL column width
Date: Thu, 9 Dec 1999 13:06:13 +0300
MIME-Version: 1.0
Content-Type: text/plain;
	charset="koi8-r"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

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.