Postgres Pro
Downloads
Home   >   mailing lists

Re: .so functions and SQL queries - Mailing list pgsql-general

From Tom Lane
Subject Re: .so functions and SQL queries
Date
Msg-id 8387.979917762@sss.pgh.pa.us
Whole thread Raw
In response to .so functions and SQL queries  (Guillaume Lémery <glemery@comclick.com>)
List pgsql-general
Tree view 
Guillaume =?ISO-8859-1?Q?L=E9mery?= <glemery@comclick.com> writes:
> So, I was wondering if it is possible to write C function, compiled as
> .so which can perform SQL queries such as SELECT or UPDATE ?

See the SPI features.  I'm not convinced this will give you any huge
performance increase, however, since you still need to get the data
in and out somehow.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: initdb doesn not create template1 database
Next
From: Tom Lane
Date:
Subject: Re: Another optimizer question