Error: could not find pathkey item to sort

Поиск
Список
Период
Сортировка
От Theerasak Maneeneim
Тема Error: could not find pathkey item to sort
Дата
Msg-id 480D3AB5.5010900@thns.co.th
обсуждение исходный текст
Ответы Re: Error: could not find pathkey item to sort  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
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(bothFROM '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.


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

Предыдущее
От: TJ O'Donnell
Дата:
Сообщение: Re: Desc Commnad in pgsql?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Desc Commnad in pgsql?