Re: [GENERAL] How to find current row number relative to window frame

2013-04-26 Thread Tom Lane
Art Ruszkowski writes: > 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

[GENERAL] How to find current row number relative to window frame

2013-04-25 Thread Art Ruszkowski
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)