Thread: UNION in views
Hi all, I am part of the team that's porting the ArsDigita Community System (ACS), a toolkit to create community-oriented db-backed websites, from Oracle to PostgreSQL. We call the projet OpenACS.We are thinking of using PG 7.1b for the port (since it'll take some time, allowing PG 7.1 to mature), because of OUTER JOINs support and because of a message by Tom Lane that I read a couple days ago where he said that subselects in the from clause are now supported in the CVS version of PG. I was wondering if UNIONs in VIEWS will be supported too. Do you have a time frame for the release of 7.1b? Any additional comments on 7.1 features,drawbacks, caveats, etc, are appreciated. Thanks, -Roberto -- Computer Science Utah State University Space Dynamics Laboratory Web Developer USU Free Software & GNU/Linux Club http://fslc.usu.edu http://www.brasileiro.net/roberto
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
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 >