On 09/04/2007 00:36, Bigjim wrote:
I am trying to combine 2 text variable togther to form the name of a VIEW. example
>
SELECT * FROM ( 'april'||'may') ;
I think you want to use EXECUTE from within a pl/pgsql function to construct and execute a query dynamically - have a look at this:
http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN HTH, Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
