pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
UNION in views
3+ messages / 3 participants
[nested] [flat]

* UNION in views
@ 2000-11-07 00:41 Roberto Mello <rmello@cc.usu.edu>
  2000-11-07 01:49 ` Re: UNION in views Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Roberto Mello @ 2000-11-07 00:41 UTC (permalink / raw)
  To: pgsql-sql

	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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: UNION in views
  2000-11-07 00:41 UNION in views Roberto Mello <rmello@cc.usu.edu>
@ 2000-11-07 01:49 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2000-11-07 01:49 UTC (permalink / raw)
  To: Roberto Mello <rmello@cc.usu.edu>; +Cc: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* RE: UNION in views
@ 2000-11-17 23:01 Diehl, Jeffrey <jdiehl@sandia.gov>
  0 siblings, 0 replies; 3+ messages in thread

From: Diehl, Jeffrey @ 2000-11-17 23:01 UTC (permalink / raw)
  To: 'Tom Lane' <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql

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
> 




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2000-11-17 23:01 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-07 00:41 UNION in views Roberto Mello <rmello@cc.usu.edu>
2000-11-07 01:49 ` Tom Lane <tgl@sss.pgh.pa.us>
2000-11-17 23:01 RE: UNION in views Diehl, Jeffrey <jdiehl@sandia.gov>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox