Re: view creation question - Mailing list 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