[postgis-users] Help with query

Pedro Doria Meunier pdoria at netmadeira.com
Fri Nov 3 11:30:49 PST 2006

This is probably not the best place to be asking such a (lame) question but
perhaps someone is gracious enough to lend me a hand. ;-)


I have the following setup in a table:


The first record which is to be found (ok easy enough :D) with a timestamp
meets a certain condition (ignition off)

The following record is for the event of ignition on again with a timestamp.


So the question here is: how can I compute the time difference between these
two records in a single query?

Better yet: finding all the records that meet the first condition (ignition
off) and the immediately following records as to compute the time
difference. ;-)


Thanks in advance!


Pedro Doria Meunier

(351) 91 302 49 72 - (351) 96 247 99 12

MSN - pdoriam at hotmail.com

ICQ - 308-182-126

Skype: pdoriam


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061103/4a0c5402/attachment.html>

More information about the postgis-users mailing list