Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1NFfix51891; Fri, 23 Feb 2001 10:41:44 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f1NFfY928017; Fri, 23 Feb 2001 10:41:34 -0500 (EST) To: Zeugswetter Andreas SB cc: "'Jaruwan Laongmal'" , pgsql-hackers@postgresql.org, pgsql-sql@postgresql.org Subject: Re: AW: ask for help !!! (emergency case) In-reply-to: <11C1E6749A55D411A9670001FA68796336820B@sdexcsrv1.f000.d0188.sd.spardat.at> References: <11C1E6749A55D411A9670001FA68796336820B@sdexcsrv1.f000.d0188.sd.spardat.at> Comments: In-reply-to Zeugswetter Andreas SB message dated "Fri, 23 Feb 2001 12:19:49 +0100" Date: Fri, 23 Feb 2001 10:41:34 -0500 Message-ID: <28013.982942894@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200102/863 X-Sequence-Number: 5008 Zeugswetter Andreas SB writes: > You probably wanted: > create view v1 as > select * from t1 > union all > select * from t2; Probably, but we don't support UNION in views before 7.1 :-( I'm not real clear on why t1 and t2 are separate tables at all in this example. Seems like making v1 be the real table, and t1 and t2 be selective views of it, would work a lot easier. regards, tom lane