Re: Error: could not find pathkey item to sort

Theerasak Maneeneim <theerasak@thns.co.th> writes:
>            I had some problem with postgresql 8.3.1. I had got an error 
> message, ERROR:  could not find pathkey item to sort, when
> I use this query statement:

>            SELECT   INTO   wk_fcstrec_dt   DISTINCT  MAX(fcstrec_dt) 
> FROM a_cusfcst                   

This is already reported and fixed, thanks.

http://archives.postgresql.org/pgsql-bugs/2008-03/msg00275.php
        regards, tom lane