Does it happen only for function call or otherwise for Insert statement also? What is your function declaration. How have you verified that in postgres it is double precision.
-----Original Message----- From: Barry Bell [mailto:barry_b...@harte-hanks.com] Sent: Tuesday, April 10, 2012 6:00 PM To: Amit Kapila Cc: pgsql-bugs@postgresql.org Subject: RE: [BUGS] BUG #6534: Passing numeric Bind variables to ODBC driver convers to "Double precision" No matter what numeric type I try to pass,(integer, numeric, currency) the ODBC driver is turning it into "Double Precision" Only If I send the value as a string Declare nvar as numeric(10,2) Nvar=1, nvar=1.0000 or nvar=1.00 will come across as "Double Precision" input bind variable. Sending Nvar="1" will work but there are issues with converting numbers to character, Any Ideas? Thanks Barry Bell, IT Department Office: 954-429-3771 x267 Fax: 954-281-1464 email barry_b...@harte-hanks.com -----Original Message----- From: Amit Kapila [mailto:amit.kap...@huawei.com] Sent: Monday, April 09, 2012 8:49 PM To: Barry Bell Cc: pgsql-bugs@postgresql.org Subject: RE: [BUGS] BUG #6534: Passing numeric Bind variables to ODBC driver convers to "Double precision" In ODBC while binding variable using SQLBindParameter(..) API you might be using SQL_DOUBLE or SQL_Numeric or some similar datatype to send the variable, that's why in postgres it is showing as "Double precision" -----Original Message----- From: pgsql-bugs-ow...@postgresql.org [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of Robert Haas Sent: Monday, April 09, 2012 7:31 PM To: barry_b...@harte-hanks.com Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #6534: Passing numeric Bind variables to ODBC driver convers to "Double precision" On Thu, Mar 15, 2012 at 3:04 PM, <barry_b...@harte-hanks.com> wrote: > The following bug has been logged on the website: > > Bug reference: 6534 > Logged by: Barry Bell > Email address: barry_b...@harte-hanks.com PostgreSQL version: > 9.1.2 Operating system: Windows Server 2003 > Description: > > Using the lastest of ODBC ANSI driver for windows 32bit ver 9.00.03 > Calling from MS VFP 9.0 > > public nvar as interger > nvar=1 > running the following sql: > "( select function_pkg(?nvar) " > > The bind variable nvar will show in postgres as "Double Precision" > format instead of integer. > > Is there a setting on the ODBC driver for incoming vairables? > If not it is a buf. Given the lack of any response here, I suggest reposting this to the pgsql-odbc mailing list. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
