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

Reply via email to