Postgres Pro
Downloads
Home   >   mailing lists

Re: losing my mind about sytnax error in window clause - Mailing list pgsql-sql

From Tom Lane
Subject Re: losing my mind about sytnax error in window clause
Date
Msg-id 1432226.1654645226@sss.pgh.pa.us
Whole thread Raw
In response to losing my mind about sytnax error in window clause  (Rein Petersen <email@reinpetersen.com>)
List pgsql-sql
Tree view 
Rein Petersen <email@reinpetersen.com> writes:
> ERROR:  syntax error at or near "BY"
> LINE 16:  WINDOW w AS ( PARITION BY locationid, partindex ORDER BY cr...
>                                  ^

If you really spelled it like that, "PARTITION BY" should work better.

            regards, tom lane

pgsql-sql by date:

Previous
From: Rein Petersen
Date:
Subject: losing my mind about sytnax error in window clause
Next
From: Rob Sargent
Date:
Subject: Re: losing my mind about sytnax error in window clause