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