Art Ruszkowski <a_@xxxxxxxxxxxxxxxxxxxxxxxxx> 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 preceding and current row) as..... from â?¦. Couldn't you make the aggregate track the current row number as part of its state? While it's a bit annoying to have to do that, I don't see any other solution that doesn't involve converting the aggregate into a full-fledged window function, which you probably don't want to do. (Even then, nodeWindowAgg.c doesn't seem to expose a function for row number within frame, only row number within partition.) regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
