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-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
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

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 using the adodb

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

[PERFORM] Use of Stored Procedures and

2006-01-17 Thread Marcos
Hi, 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. I looked for examples, but I din't good examples :(.. Somebody can help me? Thanks. Marcos. ---(end of