Re: sub-select with aggregate - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: sub-select with aggregate
Date
Msg-id 20021023174445.M37904@klaster.net
Whole thread Raw
In response to Re: sub-select with aggregate  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: sub-select with aggregate
List pgsql-sql
> On Wed, 23 Oct 2002, Tomasz Myrta wrote:
> 
> > Uz.ytkownik Stephan Szabo napisa?:
> Without group_id in the select list you couldn't do a where
> group_id = <something> if the select was a view.
I know - it was just example of query.

> Did you see the other two queries I gave?  On 7.3, both of those queries
> appear (according to explain output) to do the limiting of group_id
> inside the subquery rather than doing the subquery with all rows.
> The explanation above was why I believe it was different from your
> original query.
I saw them. So should I wait for 7.3? Currently I have 7.2 and my work 
stopped because of this.
Tomasz Myrta


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: sub-select with aggregate
Next
From: Stephan Szabo
Date:
Subject: Re: sub-select with aggregate