Can you combine text variable together to referenece a VIEW name ? - Mailing list pgsql-general

From Bigjim
Subject Can you combine text variable together to referenece a VIEW name ?
Date
Msg-id 1176075387.208303.151350@p77g2000hsh.googlegroups.com
Whole thread Raw
Responses Re: Can you combine text variable together to referenece a VIEW name ?  (Lew <lew@nospam.lewscanon.com>)
Re: Can you combine text variable together to referenece a VIEW name ?  (Raymond O'Donnell <rod@iol.ie>)
List 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


pgsql-general by date:

Previous
From: "Schwenker, Stephen"
Date:
Subject: Re: 8.2.3 AutoVacuum not running
Next
From: "Gary Winslow"
Date:
Subject: Re: Postgres Crash Running PLPGSQL Function on 8.2.3