SEO

#1 (**permalink**) 04-21-2008, 07:41 AM

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.

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

#2 (**permalink**) 04-24-2008, 06:17 PM

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...3/msg00275.php

regards, tom lane

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Error: could not find pathkey item to sort