Postgres Pro
Downloads
Home   >   mailing lists

Re: Executing an SQL query from an internal function... - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Executing an SQL query from an internal function...
Date
Msg-id 20060725233158.GD23907@surnet.cl
Whole thread Raw
In response to Executing an SQL query from an internal function...  ("Redefined Horizons" <redefined.horizons@gmail.com>)
List pgsql-general
Tree view 
Redefined Horizons wrote:
> If I am implementing an internal function in PostgreSQL with the C
> programming language, can I use one of the C API's to execute a query
> from within the function? Is there another way to execute an SQL query
> from within an internal function implemented in C?

The SPI interface is designed to do that.

http://www.postgresql.org/docs/8.1/static/spi.html

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Reece Hart
Date:
Subject: Re: Mapping/DB Migration tool
Next
From: "Christian Rengstl"
Date:
Subject: question about default value and timestamp