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;
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
