Postgres Pro
Downloads
Home   >   mailing lists

BUG #6534: Passing numeric Bind variables to ODBC driver convers to "Double precision" - Mailing list pgsql-bugs

From barry_bell@harte-hanks.com
Subject BUG #6534: Passing numeric Bind variables to ODBC driver convers to "Double precision"
Date
Msg-id E1S8Fys-0003bI-Rz@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #6534: Passing numeric Bind variables to ODBC driver convers to "Double precision"  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      6534
Logged by:          Barry Bell
Email address:      barry_bell@harte-hanks.com
PostgreSQL version: 9.1.2
Operating system:   Windows Server 2003=20
Description:=20=20=20=20=20=20=20=20

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=3D1
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.

pgsql-bugs by date:

Previous
From: Stuart Bishop
Date:
Subject: Re: BUG #6532: pg_upgrade fails on Python stored procedures
Next
From: vozhdb@gmail.com
Date:
Subject: BUG #6533: postgre server crashes by create function (create table as)