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-24 08:51:29
Message-ID: 20021024175129.M3214@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> The system doesn't realize that it can limit the subquery when the only
> things it has is the join clause and the limiting clause on the other
> table. Like Tom's message about the other view, it won't imply that
> X.foo=12345 from foo=12345 when the exposed foo is B.foo.

Is this what we should expect, or rather a bug?
The system knows how to join tables, but fails with joining views or
subselects :-(
Tomasz Myrta

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2002-10-24 08:59:10 Re: Basic question.
Previous Message andres javier garcia garcia 2002-10-24 08:15:57 Basic question.