Re: bind variables, soft vs hard parse - Mailing list pgsql-hackers

From Douglas McNaught
Subject Re: bind variables, soft vs hard parse
Date
Msg-id m2mzk5nxvu.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to bind variables, soft vs hard parse  (Marcus Engene <mengpg@engene.se>)
Responses Re: bind variables, soft vs hard parse  (Marcus Engene <mengpg@engene.se>)
List pgsql-hackers
Marcus Engene <mengpg@engene.se> writes:

> Which will be the same as the second call. There is quite a big
> difference in performance using bind variables.
>
> Does Postgres work the same? Where can I go for more info?

You can do this (or close to it) but you need to explicitly PREPARE
the query (or use the protocol-level prepare, which some client
libraries will do for you).  See the SQL documentation for PREPARE.

-Doug


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: PG_DUMP and table locking in PG7.4
Next
From: Yann Michel
Date:
Subject: Re: PG_DUMP and table locking in PG7.4