Skip site navigation (1) Skip section navigation (2)

Re: sub-select with aggregate

From: "Tomasz Myrta" <jasiek(at)klaster(dot)net>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>,Tomasz Myrta <jasiek(at)klaster(dot)net>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: sub-select with aggregate
Date: 2002-10-23 08:44:45
Message-ID: 20021023174445.M37904@klaster.net (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-sql by date

Next:From: Tomasz MyrtaDate: 2002-10-23 10:07:09
Subject: sub-select with aggregate
Previous:From: peterDate: 2002-10-23 07:50:36
Subject: Multiple Databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group