Thread: SQL queries inside a C function?

Hi everyone,

How do I get the active connection handle from inside a C function linked as a PL/pgSQL function, like:

Datum pg_do_something(PG_FUNCTION_ARGS)
{
  PGconn *conn = ....?
  // now do some SELECTs / INSERTs
  PG_RETURN_INT32(result);
}

Thanks,
Elliot

Hello

you can use a SPI interface

http://www.postgresql.org/docs/9.0/interactive/spi.html

regards

Pavel Stehule

2010/12/26 Elliot Chance <elliotchance@gmail.com>:
> Hi everyone,
>
> How do I get the active connection handle from inside a C function linked as a PL/pgSQL function, like:
>
> Datum pg_do_something(PG_FUNCTION_ARGS)
> {
>  PGconn *conn = ....?
>  // now do some SELECTs / INSERTs
>  PG_RETURN_INT32(result);
> }
>
> Thanks,
> Elliot
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>