| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
| Cc: | Sara Cohen <sarina(at)cs(dot)huji(dot)ac(dot)il>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Subqueries in select clause |
| Date: | 2001-04-18 18:33:14 |
| Message-ID: | 12360.987618794@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
"Josh Berkus" <josh(at)agliodbs(dot)com> writes:
> Until you can upgrade, though, try this approach:
> CREATE VIEW c_aggregate AS
> SELECT sum(a) as sum_a, b FROM c GROUP BY b;
> SELECT max(sum_a) FROM c_aggregate;
Unfortunately that won't work in 7.0 --- grouped views have a lot of
problems in that version, and one of the problems is that you can't
do another level of aggregating on their results.
Basically a view and a subselect are the same thing, so you can't get
around the restrictions of one by using the other...
7.1 is what Sara needs.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2001-04-18 18:41:01 | Re: RTREE on points |
| Previous Message | Diehl, Jeffrey | 2001-04-18 18:28:57 | RE: Re: DB porting questions... |