Excerpts from Jeff Turner's message of lun ene 17 07:34:29 -0300 2011:
> test=# select *, rank()+1 over (partition by bar) from t;
> ERROR: syntax error at or near "over"
> LINE 1: select *, rank()+1 over (partition by bar) from t;
The "over" stuff is part of the expression; you can't add the +1 in the
middle. This works:
select *, rank() over (partition by bar) + 1 from t;
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
pgsql-bugs by date
|Next:||From: Alvaro Herrera||Date: 2011-01-17 16:09:56|
|Subject: Re: BUG #5835: PL/Python crashes|
|Previous:||From: Tim Uckun||Date: 2011-01-17 13:23:56|
|Subject: Re: Problems with adding a is not null to a query.|