Re: .so functions and SQL queries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Guillaume Lémery <glemery(at)comclick(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: .so functions and SQL queries
Date: 2001-01-19 15:22:42
Message-ID: 8387.979917762@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Guillaume =?ISO-8859-1?Q?L=E9mery?= <glemery(at)comclick(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-01-19 15:24:42 Re: Another optimizer question
Previous Message Tony Grant 2001-01-19 15:20:43 Re: initdb doesn not create template1 database