Re: Embedded SQL in a function - Mailing list pgsql-general

From Nikolay Hristov
Subject Re: Embedded SQL in a function
Date
Msg-id 3D341AF2.8050601@mail.vega.bg
Whole thread Raw
In response to Re: Embedded SQL in a function  (Michael Meskes <meskes@postgresql.org>)
List 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


pgsql-general by date:

Previous
From: Cyrill Polikarpov
Date:
Subject: User's management
Next
From: jd@crazypenguins.postgresql.org
Date:
Subject: Re: Question: merit / feasibility of compressing frontend