comparing rows

From: "hjenkins" <hjenkins(at)uvic(dot)ca>
To: "Postgresql General" <pgsql-general(at)postgresql(dot)org>
Subject: comparing rows
Date: 2007-12-10 21:31:42
Message-ID: 2341.142.104.193.193.1197322302.squirrel@wm3.uvic.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, all,

I would like to take a timeseries of data and extract the rows of data
flanking the gaps in it. So I need to compare timestamps from two adjacent
rows, and determine if the interval is greater than the standard sampling
interval.

Thanks for any help.

Regards,
H. Jenkins

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2007-12-10 21:33:15 Re: Script to reset all sequence values in the a given DB?
Previous Message Scott Marlowe 2007-12-10 21:27:52 Re: Unable to ALTER table after SELECT data from table