Re: Functions with dynamic queries

From: Gabriel Dovalo Carril <dovalo(at)terra(dot)es>
To: "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com>
Cc: Lista SQL de postgres <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Functions with dynamic queries
Date: 2002-05-24 08:24:10
Message-ID: 3CEDF8AA.4CFF9A8C@terra.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah. 2002-05-24 11:53:17 Re: Functions with dynamic queries
Previous Message Gabriel Dovalo Carril 2002-05-23 23:37:13 Re: Functions with dynamic queries