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@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
