Re: join functions

2011/1/5 Zotov <zotov@oe-it.ru>:

> Why doesn`t work this query?
> select table1.field1, func1.field2 from table1 left outer join
> func1(table1.field1) on true where func1.field3 in (20, 100);
>
> If i have other than LEFT OUTER JOIN I can understand why
>   ERROR:  invalid reference to FROM-clause entry for table "table1"
>
> but why here?
>   for each row of table1 just evaluate func1(table1.field1)

That seems like a use case for LATERAL, which is not supported yet.

Some recent discussion seems to be
<URL:http://archives.postgresql.org/pgsql-hackers/2009-09/msg00292.php>.

Nicolas