Re: view creation question

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: "Larry White" <ljw1001(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: view creation question
Date: 2006-03-09 16:14:20
Message-ID: A6404BA5-77E9-4960-AD0F-FDE1183B6104@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Mar 10, 2006, at 0:55 , Larry White wrote:

> Is there some way to wrap these two independent queries in a
> "CREATE VIEW myview AS" statement?

CREATE VIEW myview AS
Select name, description, date from Tasks
UNION
Select name, description, date from Issues;

Michael Glaesemann
grzm myrealbox com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2006-03-09 16:30:55 Re: view creation question
Previous Message matroska 2006-03-09 16:07:24 Re: Tsearch2 cache lookup problem