Views on Unions

From: "Zot O'Connor" <zot(at)zotconsulting(dot)com>
To: postgres sql <pgsql-sql(at)hub(dot)org>
Subject: Views on Unions
Date: 2000-07-24 23:09:50
Message-ID: 397CCCBE.E1AD2806@zotconsulting.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas SMETS 2000-07-25 02:02:36 [Fwd: inserting integer in Table]
Previous Message Jan Wieck 2000-07-24 22:47:18 Re: TCL updates