Re: Generate a dynamic sequence within a query

Alban Hertroys, 21.10.2010 13:43:
> I'm currently using WebFOCUS at work and they have a LAST operator,
> referring to the value a column had in the last returned row. That's
> pretty good for stuff like this, so I wonder if it wouldn't be
> beneficial to have something like that in Postgres?

Already there since 8.4 ;)
Look into the windowing functions (in Oracle they are called analytical functions)

http://www.postgresql.org/docs/current/static/tutorial-window.html

Thomas