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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "trinchero" <trinchero(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2820: "select" faling with "distinct" clause on a subquery
Date: 2006-12-10 20:22:37
Message-ID: 14202.1165782157@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"trinchero" <trinchero(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2006-12-10 20:22:41 Re: BUG #2802: Feature request: tinyint and unsigned types
Previous Message Tom Lane 2006-12-10 20:20:50 Re: BUG #2821: xid cannot be casted to a different type