ODBC driver chances function-call in a wrong way

This is a multi-part message in MIME format.

------_=_NextPart_001_01C977F3.366E54D3
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello,

I have the following problem:

I have a PG function in my database which looks like this:

CREATE OR REPLACE FUNCTION help_sel0(IN a int,IN b char(2),OUT
master_fileset INT, OUT master_type CHAR(2), OUT highest_number INT)
RETURNS RECORD AS

$function$

DECLARE

r RECORD;

BEGIN

SELECT INTO r
master_fileset,master_type,highest_number

FROM gen_master

WHERE master_fileset=3D a

AND master_type=3D b;

master_fileset:=3Dr.master_fileset;

master_type:=3Dr.master_type;

highest_number:=3Dr.highest_number;

END;

$function$

LANGUAGE plpgsql;

When I now want to send with my ODBC-programm the following prepared
statement to the server

{SELECT * FROM gen_master_sel0(?,?);} (with the parameters 10 and 'S2')

the driver recognizes that I'm calling a "stored procedure", but he
doesn't notice the given parameter and changes the command to this

SELECT * FROM gen_master_sel0( 10, E'S2');() .

Is this a bug in the recent driver (8.3.0400) which I'm using or has
anybody any idea what I might have done wrong? I have to say this is the
first time I'm working with Postgres so maybe my function is not ok?!

I'm very thankful for ideas and suggestions :-)

Thx, Ida

------_=_NextPart_001_01C977F3.366E54D3
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Hello,<o:p></o:p>

<o:p> </o:p>

I have the following =
problem:<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

I have a PG function in my database which looks like =
this:<o:p></o:p>

<o:p> </o:p>

CREATE OR REPLACE FUNCTION help_sel0(IN a int,IN b
char(2),OUT master_fileset INT, OUT master_type CHAR(2), OUT =
highest_number
INT) RETURNS RECORD AS <o:p></o:p>

 =
 &=
nbsp; $function$<o:p></o:p>

 =
 &=
nbsp; DECLARE<o:p></o:p>

 =
 &=
nbsp; r
RECORD;<o:p></o:p>

 =
 &=
nbsp; BEGIN<o:p></o:p>

 =
 &=
nbsp; SELECT
INTO r master_fileset,master_type,highest_number =
<o:p></o:p>

 =
 &=
nbsp; FROM
gen_master<o:p></o:p>

 =
 &=
nbsp; WHERE
master_fileset=3D a<o:p></o:p>

 =
 &=
nbsp; AND
master_type=3D b;<o:p></o:p>

 =
 &=
nbsp; =
master_fileset:=3Dr.master_fileset;<o:p></o:p>

 =
 &=
nbsp; master_type:=3Dr.master_type;<o:p></o:p>

 =
 &=
nbsp; =
highest_number:=3Dr.highest_number;<o:p></o:p>

 =
 &=
nbsp; END;
<o:p></o:p>

 =
 &=
nbsp; $function$
<o:p></o:p>

 =
 &=
nbsp;
LANGUAGE plpgsql;<o:p></o:p>

<o:p> </o:p>

When I now want to send with my ODBC-programm the =
following
prepared statement to the server<o:p></o:p>

 {SELECT * FROM gen_master_sel0(?,?);} (with the
parameters 10 and ‘S2’) <o:p></o:p>

 the driver recognizes that I’m calling a =
“stored
procedure”, but he doesn’t notice the given parameter =
and
changes the command to this <o:p></o:p>

 SELECT * FROM gen_master_sel0( 10, E'S2');() =
..<o:p></o:p>

<o:p> </o:p>

Is this a bug in the recent driver (8.3.0400) which =
I’m
using or has anybody any idea what I might have done wrong? I have to =
say this
is the first time I’m working with Postgres so maybe my function =
is not
ok?!<o:p></o:p>

<o:p> </o:p>

I’m very thankful for ideas and suggestions =
J<o:p></o:p></p=
>

<o:p> </o:p>

Thx, Ida<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

</div>

</body>

</html>

------_=_NextPart_001_01C977F3.366E54D3--

ODBC driver chances function-call in a wrong way

Re: ODBC driver chances function-call in a wrong way