> 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.
In response to
pgsql-sql by date
|Next:||From: Tomasz Myrta||Date: 2002-10-23 10:07:09|
|Subject: sub-select with aggregate|
|Previous:||From: peter||Date: 2002-10-23 07:50:36|
|Subject: Multiple Databases|