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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
