Skip site navigation (1) Skip section navigation (2)

Re: prepared statement support?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: clee(at)v1(dot)wustl(dot)edu
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: prepared statement support?
Date: 2000-09-09 02:24:52
Message-ID: 27737.968466292@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Christopher Lee <clee(at)gnwy100(dot)wuh(dot)wustl(dot)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

In response to

pgsql-novice by date

Next:From: Chris McNettDate: 2000-09-09 23:39:58
Subject: ecpg
Previous:From: Christopher LeeDate: 2000-09-09 02:06:14
Subject: prepared statement support?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group