[Q] ODBC Decimal(19,6) - Mailing list pgsql-general

From V S P
Subject [Q] ODBC Decimal(19,6)
Date
Msg-id 1237263360.13010.1305782825@webmail.messagingengine.com
Whole thread Raw
In response to [Q] ODBC connect shows RELEASE / SAVEPOINT on selects  ("V S P" <toreason@fastmail.fm>)
List 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@fastmail.fm

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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: using window functions
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Postgres 8.2.x support on Windows 2008