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(at)sandia(dot)gov

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