On 5 Jan 2011, at 02:12, Zotov wrote:
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);
The approach people usually use is:
SELECT
f1, (fn).field2
FROM
(
SELECT
field1 as
On Fri, Jan 7, 2011 at 8:34 AM, Zotov wrote:
> Thank you for your answer. Sorry, what i don`t find it myself.
> But I can`t see when it will be done? If nobody can do this (maybe no time)
> what i can do to help?! I know C - Language only to read code. (I`m
> Delphi-programmer) and this is not tha
07.01.2011 13:01, Nicolas Barbier пишет:
That seems like a use case for LATERAL, which is not supported yet.
Some recent discussion seems to be
http://archives.postgresql.org/pgsql-hackers/2009-09/msg00292.php>.
Nicolas
Thank you for your answer. Sorry, what i don`t find it myself.
But I can`
2011/1/5 Zotov :
> 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 tabl
Hello, Hackers!
We have a project developed at Interbase and Firebird.
Now we try use PostgreSQL and have some problem
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
