Re: Determining Rank

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Don Drake" <dondrake(at)gmail(dot)com>, "Michael Glaesemann" <grzm(at)myrealbox(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Determining Rank
Date: 2005-02-04 21:36:12
Message-ID: opslozmmfwth1vuj@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


> Michael,
>
> That's an excellent solution, but on my table, the explain plan sucks
> and the query time is over 3 minutes when implemented. Is there a
> simple way to get a row_num without using a temporary sequence?
>
> Thanks for your help.
>
> -Don

Make your query a set returning function which iterates over the query
results and returns a number as well ?

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Joel Fradkin 2005-02-05 21:38:00 Assoclist is still slow and I am not seeing it
Previous Message Don Drake 2005-02-04 21:18:37 Re: Determining Rank