Need to subtract values between previous and current row - Mailing list pgsql-sql

From Partha Guha Roy
Subject Need to subtract values between previous and current row
Date
Msg-id 6bdfe880612150427o19bfe90ch87a972c0f5898ffb@mail.gmail.com
Whole thread Raw
Responses Re: Need to subtract values between previous and current row  (Ragnar <gnari@hive.is>)
Re: Need to subtract values between previous and current row  (Joe <dev@freedomcircle.net>)
Re: Need to subtract values between previous and current row  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-sql
Hi,<br /><br />I have a table that contains data like this:<br /><br />ID           ATIME (MM/dd/yyyy)<br />==         
====<brclear="all" />1            10/12/2006<br />2            10/14/2006<br />3            10/18/2006<br
/>4           10/22/2006 <br />5            10/30/2006<br /><br />Now I need a query that will subtract atime of row 1
fromrow 2, row2 from row3  and so on...<br /><br />Can anyone please help?<br /><br />Regards.<br /><br />-- <br
/>------------------------------<br/> Partha Guha Roy<br />***********************************************<br />Take
everythingyou like seriously, except yourselves.<br />- Rudyard Kipling  

pgsql-sql by date:

Previous
From: Markus Schaber
Date:
Subject: Re: join and sort on 'best match'
Next
From: Ragnar
Date:
Subject: Re: Need to subtract values between previous and current row