Re: Generate a dynamic sequence within a query - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Generate a dynamic sequence within a query
Date
Msg-id i9pa5e$jkq$1@dough.gmane.org
Whole thread Raw
In response to Re: Generate a dynamic sequence within a query  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Generate a dynamic sequence within a query
Next
From: zab08
Date:
Subject: GridSQL