Re: Embedded SQL in a function

From: Nikolay Hristov <charlie(at)mail(dot)vega(dot)bg>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Embedded SQL in a function
Date: 2002-07-16 13:09:06
Message-ID: 3D341AF2.8050601@mail.vega.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Meskes wrote:
> On Mon, Jul 15, 2002 at 07:28:19PM +0300, Nikolay Hristov wrote:
>
>>Is it possible to use embedded SQL in C function.
>
>
> You mean an internal function?
>
> I'm sorry, that won't work as embedded SQl internally uses libpq to
> talk to the backend. When you're inside the backend you would need to
> use the SPI interface instead. I always wanted to add that to ecpg but
> never found the time.
>
> Michael

Thank you for the responce.
I suppose I should rewrite my DB2 stored procedures in PL/pgSQL.
I hoped that there is an easy way.

Regards,
Nikolay

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-07-16 13:33:15 Re: Bad HTML in Mail List Archives
Previous Message Andrew Sullivan 2002-07-16 12:54:43 Re: memory