oracle rank() over partition by queries

On 9/11/07, sharmi Joe <sha.question@gmail.com> wrote:

Hi,
Is there a way to get the oracle's rank() over partition by queries in
postgresql? For example if I have a query like

Select Col1, Col2, RANK() OVER(PARTITION BY Col1 order by Col3 desc) as rank
from table1

Thanks in advance

See:
http://troels.arvin.dk/db/rdbms/#select-top-n

Hello Sharmi Joe,

sharmi Joe wrote:

Is there a way to get the oracle's rank() over partition by queries in
postgresql?

These are known as window functions. AFAIK Gavin Sherry is working on an
implementation for Postgres.

Regards

Markus

Thanks Markus

Markus Schiltknecht <markus@bluegap.ch> wrote: Hello Sharmi Joe,

sharmi Joe wrote:

Is there a way to get the oracle's rank() over partition by queries in
postgresql?

These are known as window functions. AFAIK Gavin Sherry is working on an
implementation for Postgres.

Regards

Markus

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

---------------------------------
Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out.