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

From Tomasz Myrta
Subject Re: sub-select with aggregate
Date
Msg-id 20021024175129.M3214@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
> 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


pgsql-sql by date:

Previous
From: andres javier garcia garcia
Date:
Subject: redirect query results to my (stdout) screen
Next
From: Achilleus Mantzios
Date:
Subject: Re: redirect query results to my (stdout) screen