Re: filtering after join
От
Peter Eisentraut
Тема
Re: filtering after join
Дата
Msg-id
200601252011.13465.peter_e@gmx.net
Ответ на
filtering after join (andrew)
Список
Дерево обсуждения
filtering after join andrew <andrew.ylzhou@gmail.com>
Re: filtering after join Michael Fuhr <mike@fuhr.org>
Re: filtering after join Peter Eisentraut <peter_e@gmx.net>
Re: filtering after join andrew <andrew.ylzhou@gmail.com>
Re: filtering after join Peter Eisentraut <peter_e@gmx.net>
Re: filtering after join andrew <andrew.ylzhou@gmail.com>
Re: filtering after join Peter Eisentraut <peter_e@gmx.net>
Re: filtering after join andrew <andrew.ylzhou@gmail.com>
Re: filtering after join Peter Eisentraut <peter_e@gmx.net>
Re: filtering after join andrew <andrew.ylzhou@gmail.com>
Re: filtering after join andrew <andrew.ylzhou@gmail.com>
Re: filtering after join Tom Lane <tgl@sss.pgh.pa.us>
Re: filtering after join andrew <andrew.ylzhou@gmail.com>
Re: filtering after join andrew <andrew.ylzhou@gmail.com>
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 по дате отправления
