From: Michael Meskes <meskes@postgresql.org>
To: UEBAYASHI 'UMA' Masao <masao@nf.enveng.titech.ac.jp>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] ecpg: why use PREPARE?
Date: Thu, 2 Dec 1999 14:05:05 +0100
Message-ID: <19991202140505.A2305@fam-meskes.de> (raw)
In-Reply-To: <19991202191428J.masao@nf.enveng.titech.ac.jp>
References: <19991202191428J.masao@nf.enveng.titech.ac.jp>
On Thu, Dec 02, 1999 at 07:14:28PM +0900, UEBAYASHI 'UMA' Masao wrote:
> example programs. I can see such lines like below in test2.pgc:
> ...
> As far, I know the differences between the normal one and the parepare
As the comment says:
/* and now the same query with prepare */
This example is just to check ecpg's functionality and to show that it is
possible to use prepare.
> one are that the prepare one:
>
> 1) prepares statement `MM' and creates cursor on it.
> 2) opens the cursor with ``using''
>
> I have no idea what these mean. My test program which is simply
> changed from ``declare cursor'' to ``prepare + declare'' seems to run
> the same way and takes the same time.
That's what supposed to happen. PREPARE is used for so-called dynamic SQL.
Just imagine a query where a variable in the where clause changes depending
on the flow of a program. Then you can either use two different cursors with
quite some work needed doubling program logic or you used give the prepared
statement the other variable via the using clause.
Or thing about an SQL statement that is dynamically created during run time.
You cannot use this without preparing it.
Hope this helps.
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De | Use PostgreSQL!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: meskes@postgresql.org, masao@nf.enveng.titech.ac.jp
Subject: Re: [INTERFACES] ecpg: why use PREPARE?
In-Reply-To: <19991202140505.A2305@fam-meskes.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox