pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
Message-ID: <01cc01bf422d$07003980$0d8cdac3@aktrad.ru> (raw)

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.





Message-ID: <01cc01bf422d$07003980$0d8cdac3@aktrad.ru>
Permalink:  ../01cc01bf422d$07003980$0d8cdac3@aktrad.ru/
Also on:    postgresql.org/message-id/01cc01bf422d$07003980$0d8cdac3@aktrad.ru

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: hook@aktrad.ru
  Subject: Re: ODBC and DECIMAL column width
  In-Reply-To: <01cc01bf422d$07003980$0d8cdac3@aktrad.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox