Re: [PERFORM] Use of Stored Procedures and

2006-01-19 Thread Markus Schaber
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 us

Re: [PERFORM] Use of Stored Procedures and

2006-01-19 Thread Marcos
> 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 store

Re: [PERFORM] Use of Stored Procedures and

2006-01-19 Thread Markus Schaber
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

Re: [PERFORM] Use of Stored Procedures and

2006-01-19 Thread Marcos
> What statements? Sorry. Statements is my code. > 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

Re: [PERFORM] Use of Stored Procedures and

2006-01-18 Thread Michael Fuhr
On Tue, Jan 17, 2006 at 09:04:53AM +, Marcos wrote: > I already read the documentation for to use the SPI_PREPARE and > SPI_EXEC... but sincerely I don't understand how I will use this > resource in my statements. What statements? What problem are you trying to solve? -- Michael Fuhr -