From: Dinesh Pandey <dpandey@secf.com>
To: 'PostgreSQL' <pgsql-sql@postgresql.org>
Subject: Prepared query ?
Date: Thu, 14 Apr 2005 19:58:40 +0530
Message-ID: <20050414143144.1704853689@svr1.postgresql.org> (raw)
How can I
1. Write a prepared query and
2. Set values at run time and
3. Execute that query for different values.
LOOP
...
...
sql := INSERT INTO MYTABLE VALUES(?, ?);
..
--EXECUTE (sql);
END LOOP;
Regards
Dinesh Pandey
----------------------------------------------------------------------------
------
Dinesh Pandey
Sr. Software Engineer
Second Foundation (India) Pvt. Ltd.
Plot# 52
Industrial Area, Phase II
Chandigarh. (India)
PH: (O) 0172-2639202, Extn: 233
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-sql@postgresql.org
Cc: dpandey@secf.com
Subject: Re: Prepared query ?
In-Reply-To: <20050414143144.1704853689@svr1.postgresql.org>
* 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