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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
