From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | hackers(at)postgreSQL(dot)org (PostgreSQL-development) |
Subject: | Views on UNIONs |
Date: | 1998-01-09 21:33:05 |
Message-ID: | 199801092133.QAA21411@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
While you can do a UNION of views, you can not do a VIEW of UNIONs.
This is OK:
select * from view1 UNION select * from view2;
This is not OK:
create view testv as select * from test1 UNION select * from test2;
Does the standard allow this? Thomas? I currently print a 'not
implemented' message.
Informix does not allow it, and I can't figure out how to do it with the
re-write system yet.
--
Bruce Momjian
maillist(at)candle(dot)pha(dot)pa(dot)us
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-01-09 21:48:59 | Re: [HACKERS] Disk block size issues. |
Previous Message | Bruce Momjian | 1998-01-09 20:10:11 | Re: [HACKERS] column labels now with obligatory 'as' |