Message-ID: <480D3AB5.5010900@thns.co.th>
Date: Mon, 21 Apr 2008 13:09:09 -1200
From: Theerasak Maneeneim <theerasak@thns.co.th>
Reply-To: theerasak@thns.co.th
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Error: could not find pathkey item to sort
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi Everyone,

           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                   
          WHERE
                   cscd = '2203'
               AND    cs_partno = '35732SSA'
               AND    delipnt_no = '001'
               AND    plantcd_no = '003'
               AND    locatto = trim(both FROM 'SS')
               AND    fcstrec_dt < '20080910'
               AND    latest_flg = 'N';


       I have not ever seen the error in version 8.1 and 8.2. Now, I 
have already revised my program by removed the word "DISTINCT" but I 
want to know what is cause of this error. Could you please to explain to me?

Thank you very much.