subject:"\[SQL\] Error\: could not find pathkey item to sort"

Re: [SQL] Error: could not find pathkey item to sort

2008-04-21 Thread Tom Lane

Theerasak Maneeneim <[EMAIL PROTECTED]> 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_cus

[SQL] Error: could not find pathkey item to sort

2008-04-20 Thread Theerasak Maneeneim

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