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