Can you combine text variable together to referenece a VIEW name ?

From: "Bigjim" <bigjim(dot)still(at)rogers(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Can you combine text variable together to referenece a VIEW name ?
Date: 2007-04-08 23:36:27
Message-ID: 1176075387.208303.151350@p77g2000hsh.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there,
I am trying to combine 2 text variable togther to form the name of a
VIEW. example

SELECT * FROM ( 'april'||'may') ;

I have a 12 different views and I want to be able to select a
different view depending on the contents of 2 fields in a database.

Has anyone done this before or have any ideas on how to do it ?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2007-04-09 03:28:17 == PostgreSQL Weekly News - April 08 2007 ==
Previous Message paul rivers 2007-04-08 22:02:16 Re: table partitioning and plpgsql functions in 8.2.3