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

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Ida Schonfeld <Ida(dot)Schonfeld(at)oclc(dot)org>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC driver chances function-call in a wrong way
Date: 2009-01-17 05:07:34
Message-ID: 49716796.1080909@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Ida Schonfeld wrote:
> 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= a
>
> AND master_type= b;
>
> master_fileset:=r.master_fileset;
>
> master_type:=r.master_type;
>
> highest_number:=r.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 above call is wrong.
You should prepare the ODBC style procedure call
{call gen_master_sel0(?,?)}
or you can simply prepare the pg-specific procedure call
SELECT * FROM gen_master_sel0(?,?)
.

regards,
Hiroshi Inoue

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message joser 2009-01-19 19:11:17 Re: Psqlodbc install problem
Previous Message jurijs Nezencevs 2009-01-16 23:02:02 Re: ODBCNET