Re: oracle rank() over partition by queries

From: SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: oracle rank() over partition by queries
Date: 2007-09-14 12:51:28
Message-ID: 888810.67830.qm@web31105.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Markus

Markus Schiltknecht <markus(at)bluegap(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2007-09-14 13:22:58 Re: [GENERAL] ascii() for utf8
Previous Message Markus Schiltknecht 2007-09-14 12:38:12 Re: oracle rank() over partition by queries