filtering after join - Mailing list pgsql-general

From andrew
Subject filtering after join
Date
Msg-id 29d3b0b90601250949t1991b0f9l6026405b80e9dc28@mail.gmail.com
Whole thread Raw
Responses Re: filtering after join  (Alban Hertroys <alban@magproductions.nl>)
List pgsql-general
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-general by date:

Previous
From: MargaretGillon@chromalloy.com
Date:
Subject: Re: Constraint that compares and limits field values
Next
From: andrew
Date:
Subject: Re: user defined function