Re: Functions with dynamic queries - Mailing list pgsql-sql

From Gabriel Dovalo Carril
Subject Re: Functions with dynamic queries
Date
Msg-id 3CEDF8AA.4CFF9A8C@terra.es
Whole thread Raw
In response to Functions with dynamic queries  (Gabriel Dovalo Carril <dovalo@terra.es>)
Responses Re: Functions with dynamic queries  ("Rajesh Kumar Mallah." <mallah@trade-india.com>)
List pgsql-sql
"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.


pgsql-sql by date:

Previous
From: Gabriel Dovalo Carril
Date:
Subject: Re: Functions with dynamic queries
Next
From: "Rajesh Kumar Mallah."
Date:
Subject: Re: Functions with dynamic queries