Re: Use of Stored Procedures and

Поиск
Список
Период
Сортировка
От Markus Schaber
Тема Re: Use of Stored Procedures and
Дата
Msg-id 43CF74BD.7000100@logix-tt.com
обсуждение исходный текст
Ответ на Re: Use of Stored Procedures and  (Marcos <mjs_ops@gmx.net>)
Ответы Re: Use of Stored Procedures and  (Marcos <mjs_ops@gmx.net>)
Список pgsql-performance
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 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.

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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Marcos
Дата:
Сообщение: Re: Use of Stored Procedures and
Следующее
От: Marcos
Дата:
Сообщение: Re: Use of Stored Procedures and