On 2/29/2016 3:55 PM, da...@andl.org wrote:
What I need (to find or create) is a ‘pure’ C language API to support
a Postgres server extension. By ‘pure’ I mean one that has no
knowledge of Postgres internals and that could be called by a generic
interface provided by some other tool that can support C language APIs.
The reason is that I’m looking to integrate a new language (*Andl*)
into Postgres. To do that I need to find or create a ‘pure’ C-language
API to interface with:
1.The generic language call interface (pl_language_handler), which
must handle conversion of Incoming language call parameters and
outgoing language call return value.
1.The backend query execution interface (SPI), which must handle
conversion of outgoing query parameters and incoming query result values.
by "server extension" do you mean, you want to use Andi as a "PL/Andi"
so you can write stored procedures i Andi callable within SQL queries?
or do you mean, you want your Andi programs to be able to execute normal
postgresql queries as a regular client ?
for the first, see
http://www.postgresql.org/docs/9.5/static/plhandler.html
for the latter, see
http://www.postgresql.org/docs/9.5/static/libpq.html
--
john r pierce, recycling bits in santa cruz