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 <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
