From: Gabriel Dovalo Carril <dovalo@terra.es>
To: Rajesh Kumar Mallah. <mallah@trade-india.com>
Cc: Lista SQL de postgres <pgsql-sql@postgresql.org>
Subject: Re: Functions with dynamic queries
Date: Fri, 24 May 2002 10:24:10 +0200
Message-ID: <3CEDF8AA.4CFF9A8C@terra.es> (raw)
References: <3CECC5C5.BDF77592@terra.es>
<200205231914.27923.mallah@trade-india.com>
"Rajesh Kumar Mallah." escribió:
>
> I guess the examples on standard docs explain it.
> dont they?
>
Hi Rajesh,
I have read docs examples again, and even examples at:
http://www.brasileiro.net/postgres/plpgsql/plpgsql-description.html
section 1.2.5.3, which explains how to execute dynamic queries.
At the end of this section there is an example with a comment:
-- This works because we are not substituting any variables
-- Otherwise is would fail.
And I need to know how can a query be executed substituting
variables.
Thanks,
--
Gabriel D.
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: dovalo@terra.es, mallah@trade-india.com
Subject: Re: Functions with dynamic queries
In-Reply-To: <3CEDF8AA.4CFF9A8C@terra.es>
* 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