Re: prepared statement support?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: prepared statement support?
Дата
Msg-id 27737.968466292@sss.pgh.pa.us
обсуждение исходный текст
Ответ на prepared statement support?  (Christopher Lee <clee@gnwy100.wuh.wustl.edu>)
Список pgsql-novice
Christopher Lee <clee@gnwy100.wuh.wustl.edu> writes:
> I'm new to postgresql and RDBMS in general and was wondering if it supported
> "prepared statements" or some equivalent.

Not directly, but PLPGSQL-language functions cache plans for their
contained queries, so you can get the effect if you can push your
computation into function calls, triggers, etc.

Also, the backend's SPI interface for C-coded functions supports cached
plans, but that's got a bit of a steep learning curve ...

            regards, tom lane

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

Предыдущее
От: Christopher Lee
Дата:
Сообщение: prepared statement support?
Следующее
От: David Slayton
Дата:
Сообщение: Multiple Selects