Postgres Pro
Downloads
Home   >   mailing lists

Re: Query regarding Bind data type, precision, scale while using psqlodbc - Mailing list pgsql-odbc

From Dave Cramer
Subject Re: Query regarding Bind data type, precision, scale while using psqlodbc
Date
Msg-id CADK3HHKcm-1NNDtjXjEjEqsLDQ0Uks0OoqkiJxubgr746jafJA@mail.gmail.com
Whole thread Raw
In response to Query regarding Bind data type, precision, scale while using psqlodbc  (Abhishek Kumar <abhishek.aak0@gmail.com>)
List pgsql-odbc
Tree view


On Thu, 11 Jul 2024 at 01:19, Abhishek Kumar <abhishek.aak0@gmail.com> wrote:
Hi,

I am trying to use psqlodbc native driver with my ODBC application. While using this, SQLColumns API returns me the following information for the below Data types :

1. Decimal : datatype = 2, precision = 28, scale = 6
2. Numeric : datatype = 2, precision = 28, scale = 6
3. Money :    datatype = 6, precision = 10, scale = 0

based on PostgreSQL: Documentation: 16: 8.1. Numeric Types  it would appear the precision and scale for Decimal and Numeric are incorrect.

As for Money. Just don't use it.

As for official documentation, there does not appear to be any.

Dave

pgsql-odbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Which version of psqlODBC should I install?
Next
From: Dave Cramer
Date:
Subject: Re: DataType bytea Precision returning a negative value