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

Hi, Marcos,

Marcos wrote:
>>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.
>
> I'm using the adodb to call the stored procedure (plpgsql).

So your statements are inside a plpgsql stored procedure, important to
know that.

AFAIK, plpgsql uses prepared statements internally, so it should not be
necessary to use them explicitly.

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