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 по дате отправления: