Skip site navigation (1) Skip section navigation (2)

Re: BUG #5841: rank()+1 fails, 1+rank() succeeds

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Jeff Turner <jeff(at)biccard(dot)com>
Cc: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5841: rank()+1 fails, 1+rank() succeeds
Date: 2011-01-17 15:10:19
Message-ID: 1295276957-sup-5631@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2011-01-17 16:09:56
Subject: Re: BUG #5835: PL/Python crashes
Previous:From: Tim UckunDate: 2011-01-17 13:23:56
Subject: Re: Problems with adding a is not null to a query.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group