Ruben Gouveia <[EMAIL PROTECTED]> writes:
> Does postgreSQL have an equivalent of the Oracle's "rank() over by
> partition"?
No. There's some work in progress that might or might not be ready
in time for 8.4 ...
regards, tom lane
--
Sent via pgsql-general mailing list (
Does postgreSQL have an equivalent of the Oracle's "rank() over by
partition"?
Here's what i have so far but it doesn't work:
select id,
sum(case when key = 5 then 1 else 0 end),
sum(case when key = 6 then 1 when key = 7 then 1 else 0 end),
sum(case when l.status = 6 then cos
Thanks Markus
Markus Schiltknecht <[EMAIL PROTECTED]> 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
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)
On 9/11/07, sharmi Joe <[EMAIL PROTECTED]> 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
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
