9.0RC1 error variable not found in subplan target lists
От | Andrus |
---|---|
Тема | 9.0RC1 error variable not found in subplan target lists |
Дата | |
Msg-id | 924AEDA7FD6349C1A2D09D1C0D02BE24@andrusnotebook обсуждение исходный текст |
Ответ на | Re: How to force select to return exactly one row (Brett Mc Bride <brett.mcbride@deakin.edu.au>) |
Ответы |
Re: 9.0RC1 error variable not found in subplan target lists
Re: 9.0RC1 error variable not found in subplan target lists |
Список | pgsql-general |
In 9.0 RC1 query below causes error Variable not found in subplan target lists In earlier version this query works OK. How to fix ? Andrus. SELECT * FROM (select 1) xtoode LEFT JOIN (SELECT hmguid.toode, COALESCE(hinnamtr.hinnak,klient.hinnak ) AS hinnak FROM ( SELECT hmhinnak.toode, ''::char as guid FROM ( select ''::char as toode, 1 as prioriteet ) prioriteet JOIN ( SELECT ''::char as toode, ''::text as guid, 1 as prioriteet ) hmhinnak USING (toode,prioriteet) ) hmguid JOIN (select ''::char as guid, ''::char as hinnak) hinnamtr USING (guid) LEFT JOIN klient ON klient.kood='' ) temphinnaks on true;
В списке pgsql-general по дате отправления: