Re: BUG #2820: "select" faling with "distinct" clause on a subquery - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2820: "select" faling with "distinct" clause on a subquery
Date
Msg-id 14202.1165782157@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2820: "select" faling with "distinct" clause on a subquery  ("trinchero" <trinchero@gmail.com>)
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #2802: Feature request: tinyint and unsigned types
Next
From: Stephen Frost
Date:
Subject: Re: BUG #2802: Feature request: tinyint and unsigned types