[Q] ODBC Decimal(19,6)

From: "V S P" <toreason(at)fastmail(dot)fm>
To: pgsql-general(at)postgresql(dot)org
Subject: [Q] ODBC Decimal(19,6)
Date: 2009-03-17 04:16:00
Message-ID: 1237263360.13010.1305782825@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I declared a field as DECIMAL(19,6)

when doing select thatfield from tb1

for some reason ODBC thinks that it is a double

I think it has to be a string, otherwise precision is lost
or am I not understanding this right?

I tried to do
select thefield\\:\\:varchar

but for some reason that did not work yet.

thanks in advance,
Vlad
--
V S P
toreason(at)fastmail(dot)fm

--
http://www.fastmail.fm - Access your email from home and the web

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2009-03-17 04:22:09 Re: Postgres 8.2.x support on Windows 2008
Previous Message Tom Lane 2009-03-17 03:58:25 Re: using window functions