Re: obtain the difference between successive rows - Mailing list pgsql-general

On 20/10/2012 11:54, ochaussavoine wrote:
> Hi,
> I have a table 'tmvt' with a field 'created' in the row, and would like to
> compute the difference between successive rows. The solution I found is:
>
> It is complicate and very long to perform. The problem could be simply
> solved with MySql by creating a new field and updating it using a statement
> with @.
> I beleive this is a common problem for users. Do you know a simpler solution
> with postgreSql?

I think you can do it with a window function.

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

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie