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