Re: [GENERAL] dynamic sql in PL-Pgsql ?

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
------------------------------------------------------------------

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general