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

From Michael Meskes
Subject Re: Embedded SQL in a function
Date
Msg-id 20020716085231.GA3352@feivel.credativ.de
Whole thread Raw
In response to Embedded SQL in a function  (Nikolay Hristov <charlie@mail.vega.bg>)
List pgsql-general
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
--
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!

pgsql-general by date:

Previous
From: Holger Klawitter
Date:
Subject: Re: JOIN and LIKE
Next
From: Curt Sampson
Date:
Subject: Re: Pushing PostgreSQL to the Limit (urgent!)