BUG #6534: Passing numeric Bind variables to ODBC driver convers to "Double precision"

From: barry_bell(at)harte-hanks(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6534: Passing numeric Bind variables to ODBC driver convers to "Double precision"
Date: 2012-03-15 19:04:58
Message-ID: E1S8Fys-0003bI-Rz@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6534
Logged by: Barry Bell
Email address: barry_bell(at)harte-hanks(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2012-03-15 22:08:50 Re: BUG #6532: pg_upgrade fails on Python stored procedures
Previous Message vozhdb 2012-03-15 14:33:35 BUG #6533: postgre server crashes by create function (create table as)