RE: UNION in views

I'd actually like to see a view a union.  I have a database where I've split
up each day's data into a separate table.  I had to do this to keep the
number of records to a usable level.  Now, if I want to do a query over the
last several days, I have grief.  I have kludged a system together which
rewrites my sql and (attempts to) handle group by, limit and order by
clauses.  But I'd like to have a cleaner solution.

Any plans?

Mike Diehl,
Network Monitoring Tool Devl.
284-3137
jdiehl@sandia.gov


> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: November 06, 2000 6:50 PM
> To: Roberto Mello
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] UNION in views
> 
> 
> Roberto Mello <rmello@cc.usu.edu> writes:
> >     I was wondering if UNIONs in VIEWS will be supported too.
> 
> Already there for 7.1.
> 
>             regards, tom lane
>