losing my mind about sytnax error in window clause

From: Rein Petersen <email(at)reinpetersen(dot)com>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: losing my mind about sytnax error in window clause
Date: 2022-06-07 23:03:42
Message-ID: CAMj5WPQDan-kuny1GGC5GWFt6jcOyrSbQHd+g0Ga15vqs8XjbA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Folks,

I've been reading the docs over and again, searching exhaustively for
examples on the internet to help me here and I'm ready to give up.

I have a query using windows function:

SELECT
last_value ( typechange ) OVER w,
pindex,
lid,
last_value ( modified ) OVER w,
last_value ( created ) OVER w,
last_value ( modifiedby ) OVER w,
last_value ( createby ) OVER w,
last_value ( cost ) FILTER ( WHERE cost IS NOT NULL ) OVER w,
last_value ( sell ) FILTER ( WHERE sell IS NOT NULL ) OVER w
FROM ps._delta_ext
WHERE pindex = Ppindex AND
( Plid IS NULL OR lid = Plid ) AND
( Ptimestamp IS NULL OR modified <= Ptimestamp )
GROUP BY lid, pindex
WINDOW w AS ( PARITION BY lid, pindex ORDER BY created );
Complains about syntax error in the WINDOW cause (last line) on [PARTITION]
BY:
/* messages
ERROR: syntax error at or near "BY"
LINE 16: WINDOW w AS ( PARITION BY locationid, partindex ORDER BY cr...
^
SQL state: 42601
Character: 2724
*/

Maybe my error is clear to someone else, could really use helping hand,
thanks.

Rein

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2022-06-07 23:40:26 Re: losing my mind about sytnax error in window clause
Previous Message Erik Brandsberg 2022-06-05 14:37:23 Re: Strange behavior of transcations