How to find current row number relative to window frame - Mailing list pgsql-general

From Art Ruszkowski
Subject How to find current row number relative to window frame
Date
Msg-id 20130425200615.50866fd1@prudenttradingsystems.com
Whole thread Raw
Responses Re: How to find current row number relative to window frame
List pgsql-general
Hello,

I have a user defined aggregate function and in Sfunc I need to
reference current row number relative to window frame. Ideallly I would like to have following construct:

select my_aggregate(x,current_row_number_relative_to window) over
(order by y rows between n preceding and current row) as..... from ….


Any ideas how I can do this.  Thanks Art.


pgsql-general by date:

Previous
From: Sergey Konoplev
Date:
Subject: Open transaction with 'idle' (not 'idle in transaction') status
Next
From: Adarsh Sharma
Date:
Subject: Re: Replication terminated due to PANIC