Received: from grumpy.usu.edu (grumpy.usu.edu [129.123.1.86]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA70dGs54002 for ; Mon, 6 Nov 2000 19:39:16 -0500 (EST) (envelope-from rmello@cc.usu.edu) Received: from cc.usu.edu ("port 3554"@slxwy.dorms.usu.edu [129.123.236.160]) by cc.usu.edu (PMDF V5.2-32 #39375) with ESMTP id <01JW887WHZ64A8D25V@cc.usu.edu> for pgsql-sql@postgresql.org; Mon, 6 Nov 2000 17:38:51 MST Date: Mon, 06 Nov 2000 17:41:28 -0700 From: Roberto Mello Subject: UNION in views To: pgsql-sql@postgresql.org Message-id: <3A074FB8.D66D2850@cc.usu.edu> MIME-version: 1.0 X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.2.16 i586) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en, pt-BR X-Archive-Number: 200011/44 X-Sequence-Number: 75 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