filtering after join - Mailing list pgsql-sql

From andrew
Subject filtering after join
Date
Msg-id 29d3b0b90601250927o2a5ee6e6mc33a7647da4438ce@mail.gmail.com
Whole thread Raw
Responses Re: filtering after join  (Michael Fuhr <mike@fuhr.org>)
Re: filtering after join  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
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;

But I want to apply foo() to the tuples generated by the join
operation. How can I do that?
Thanks!

--
andrew


pgsql-sql by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Changing the transaction isolation level within the stored procedure?
Next
From: "Owen Jacobson"
Date:
Subject: Re: psql in the command line