Re: Generate a dynamic sequence within a query

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Generate a dynamic sequence within a query
Date: 2010-10-21 12:02:54
Message-ID: i9pa5e$jkq$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message zab08 2010-10-21 12:26:56 GridSQL
Previous Message Alban Hertroys 2010-10-21 11:43:14 Re: Generate a dynamic sequence within a query