Re: filtering after join - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: filtering after join
Date
Msg-id 200601252011.13465.peter_e@gmx.net
Whole thread Raw
In response to filtering after join  (andrew <andrew.ylzhou@gmail.com>)
Responses Re: filtering after join  (andrew <andrew.ylzhou@gmail.com>)
List pgsql-sql
andrew wrote:
> I want to use a UDF to filter tuples t that are generated after a
> join. More specifially, I have a UDF foo(record), which computes a
> value for a given tuple.  I can do the filtering before the join.
> e.g.:
>
> select * from A, B where foo(A)<2 and A.a=B.b;

What makes you think that the filtering happens before the join here?  
And why would it matter?  The results should be all the same.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: filtering after join
Next
From: andrew
Date:
Subject: Re: filtering after join