Re: dynamic sql in PL-Pgsql ? - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: dynamic sql in PL-Pgsql ?
Date
Msg-id 48DD4862.4060603@iol.ie
Whole thread Raw
In response to dynamic sql in PL-Pgsql ?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
On 26/09/2008 21:19, Gauthier, Dave wrote:
> As you can see, the select statement needs to be dynamic in that the
> column name is stored in a variable.
>
>
> Can this be done?

http://www.postgresql.org/docs/8.3/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: dynamic sql in PL-Pgsql ?
Next
From: Tom Lane
Date:
Subject: Re: Is there any way to reliably influence WHERE predicate evaluation ordering?