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

From ochaussavoine
Subject obtain the difference between successive rows
Date
Msg-id 1350730462060-5729149.post@n5.nabble.com
Whole thread Raw
Responses Re: obtain the difference between successive rows  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
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?



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/obtain-the-difference-between-successive-rows-tp5729149.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Thalis Kalfigkopoulos
Date:
Subject: pgwatch: installs but doesn't display anything
Next
From: Raymond O'Donnell
Date:
Subject: Re: obtain the difference between successive rows