Re: BUG #2820: "select" faling with "distinct" clause on a subquery

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #2820: "select" faling with "distinct" clause on a subquery
Дата
Msg-id 14202.1165782157@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #2820: "select" faling with "distinct" clause on a subquery  ("trinchero" <trinchero@gmail.com>)
Список pgsql-bugs
"trinchero" <trinchero@gmail.com> writes:
> SELECT U_Listino.U_LISTINO_ID FROM U_Listino
>  WHERE U_Listino.U_TIPOLIS_ID IN (SELECT DISTINCT U_TipoLis.U_TIPOLIS_ID
> FROM U_TipoLis);

> This give error:
> could not find pathkey item to sort

This has already been reported and fixed, but thanks for letting us know!

            regards, tom lane

В списке pgsql-bugs по дате отправления: