[Q] ODBC Decimal(19,6)

Поиск
Список
Период
Сортировка
От V S P
Тема [Q] ODBC Decimal(19,6)
Дата
Msg-id 1237263360.13010.1305782825@webmail.messagingengine.com
обсуждение исходный текст
Ответ на [Q] ODBC connect shows RELEASE / SAVEPOINT on selects  ("V S P" <toreason@fastmail.fm>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: using window functions
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Postgres 8.2.x support on Windows 2008