ECPG and SQL function

From: Michaël Fiey <m(dot)fiey(at)futuresoundtech(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: ECPG and SQL function
Date: 2000-08-24 18:57:00
Message-ID: 002701c00dfd$160e5960$6400a8c0@pc03
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I wrote a sql funtion which accept 1 varchar in and return an int4.
I try to use this function in a C program with ECPG.
The command : "exec sql select myfunction('myargument') into :res" works fine
but :
"mycommand=select myfonction('mychangingargument')
sql prepare myprep from mycommand
and sql exec execute myprep" does not
and
"mycommand=select myfonction('mychangingargument') into :res
sql prepare myprep from mycommand
and sql exec execute myprep using :res" does not any more.

I got the error "Too few argument" or "Too many argument".

thanks for any kind of help.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 2000-08-24 19:03:22 Re: Importing into Postgres from a csv file
Previous Message Matthew Rice 2000-08-24 18:20:32 Creating a DB for another user (or...)