Re: Executing an SQL query from an internal function...

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Redefined Horizons <redefined(dot)horizons(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Executing an SQL query from an internal function...
Date: 2006-07-25 23:31:58
Message-ID: 20060725233158.GD23907@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christian Rengstl 2006-07-26 05:26:09 question about default value and timestamp
Previous Message Reece Hart 2006-07-25 23:23:39 Re: Mapping/DB Migration tool