Re: select changes in row values?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 28 Jun 2007 06:03:12 +0200
Message-ID: <46833300$0$22910$426a34cc@news.free.fr>

"aksel.schmidt" <axl.schmidt_at_gmail.com> a écrit dans le message de news: 1183002507.493893.104200_at_k79g2000hse.googlegroups.com...
| there is an ordering - just left out for simplicity
| assume another column named 'timestamp' exists - some client is then
| asked to put a row in the table (timestamp, value) on a periodical
| basis. this timestamp value is continously incrementing and used for
| ordering the select
|
| after a while, another client wants to retrieve only changes over time
| in those values (there are many other columns which values changes on
| each insert - it is thus not the inserting clients fault)
|
| does it make sense now?
|
| /aksel
|

Have a look at lag/lead functions.

Regards
Michel Cadot Received on Wed Jun 27 2007 - 23:03:12 CDT