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  (Dmitriy Igrishin <dmitigr@gmail.com>)
Re: 9.0RC1 error variable not found in subplan target lists  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Index on points
Следующее
От: Dmitriy Igrishin
Дата:
Сообщение: Re: 9.0RC1 error variable not found in subplan target lists