filtering after join

From: andrew <andrew(dot)ylzhou(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: filtering after join
Date: 2006-01-25 17:27:33
Message-ID: 29d3b0b90601250927o2a5ee6e6mc33a7647da4438ce@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Owen Jacobson 2006-01-25 17:43:49 Re: psql in the command line
Previous Message Jaime Casanova 2006-01-25 16:46:12 Re: Changing the transaction isolation level within the stored procedure?