Re: prepared statement support? - Mailing list pgsql-novice

From Tom Lane
Subject Re: prepared statement support?
Date
Msg-id 27737.968466292@sss.pgh.pa.us
Whole thread Raw
In response to prepared statement support?  (Christopher Lee <clee@gnwy100.wuh.wustl.edu>)
List 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 by date:

Previous
From: Christopher Lee
Date:
Subject: prepared statement support?
Next
From: David Slayton
Date:
Subject: Multiple Selects