Views on Unions - Mailing list pgsql-sql

From Zot O'Connor
Subject Views on Unions
Date
Msg-id 397CCCBE.E1AD2806@zotconsulting.com
Whole thread Raw
List pgsql-sql
under 6.5.3 I see that I cannot do Views on Unions.

Is this still true?  This seems odd since a UNION should be a an
R_Table....

Also it seems that I could not do a SELECT INTO or CREATE TABLE AS with
a union (I get an error at union).

Is there a syntax (i.e. using ()'s) that will work?

-- 
Zot O'Connor

http://www.ZotConsulting.com
http://www.WhiteKnightHackers.com


pgsql-sql by date:

Previous
From: Jesus Aneiros
Date:
Subject: RULES on PostgreSQL
Next
From: Thomas SMETS
Date:
Subject: [Fwd: inserting integer in Table]