From: Theerasak Maneeneim <theerasak@thns.co.th>
To: pgsql-sql@postgresql.org
Subject: Error: could not find pathkey item to sort
Date: Mon, 21 Apr 2008 13:09:09 -1200
Message-ID: <480D3AB5.5010900@thns.co.th> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: theerasak@thns.co.th
Subject: Re: Error: could not find pathkey item to sort
In-Reply-To: <480D3AB5.5010900@thns.co.th>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox