comparing rows - Mailing list pgsql-general

From hjenkins
Subject comparing rows
Date
Msg-id 2341.142.104.193.193.1197322302.squirrel@wm3.uvic.ca
Whole thread Raw
Responses Re: comparing rows
List 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


pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Unable to ALTER table after SELECT data from table
Next
From: "Pavel Stehule"
Date:
Subject: Re: Script to reset all sequence values in the a given DB?