Re: Embedded SQL in a function

Поиск
Список
Период
Сортировка
От Nikolay Hristov
Тема Re: Embedded SQL in a function
Дата
Msg-id 3D341AF2.8050601@mail.vega.bg
обсуждение исходный текст
Ответ на Re: Embedded SQL in a function  (Michael Meskes <meskes@postgresql.org>)
Список 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 по дате отправления:

Предыдущее
От: Cyrill Polikarpov
Дата:
Сообщение: User's management
Следующее
От: jd@crazypenguins.postgresql.org
Дата:
Сообщение: Re: Question: merit / feasibility of compressing frontend