2011/1/5 Zotov <zo...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
