Re: Use of Stored Procedures and - Mailing list pgsql-performance

Hi, Marcos,

Marcos wrote:

>>What problem are you trying to solve?
>
> I want know how I make to use a prepared plan
> ( http://www.postgresql.org/docs/8.1/static/sql-prepare.html ). I read
> that I need to use the SPI_PREPARE and SPI_EXEC in my code, but I didn't
> understand how make it.

Which interface are you using to connect to PostgreSQL? libpq, libpqxx,
pgjdbc, python-popy?

E. G. PGJDBC handles prepared plans transparently by using the
PreparedStatement class.

If you use command line PSQL, you can use the PREPARE commands.

Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org