Re: AW: ask for help !!! (emergency case)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
Cc: "'Jaruwan Laongmal'" <jaruwan(at)gits(dot)net(dot)th>, pgsql-hackers(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: AW: ask for help !!! (emergency case)
Date: 2001-02-23 15:41:34
Message-ID: 28013.982942894@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jaume Teixi 2001-02-23 15:49:16 hacker mechanism for m$access -> pgsql on different language systems
Previous Message Tom Lane 2001-02-23 15:29:59 Re: Lock structures

Browse pgsql-sql by date

  From Date Subject
Next Message Tod McQuillin 2001-02-23 15:43:21 Re: sum(bool)?
Previous Message Josh Berkus 2001-02-23 15:34:42 Re: Can a function return a record set?