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
>