Postgres Pro
Downloads
Home   >   mailing lists

Select values by interval - Mailing list pgsql-sql

From Markus Wolters
Subject Select values by interval
Date
Msg-id trinity-9d150dc2-4428-4d05-a7a8-9ab52fcef606-1448296662813@3capp-gmx-bs03
Whole thread Raw
Responses Re: Select values by interval
Re: Select values by interval
List pgsql-sql
Tree view 
Hi all,

I have a table with value and timestamp columns. What I like to do (but am unable to find a solution) is to select the
last(value)timestamp combination in every X minute interval where timestamp is between N and M. Is this possible with
pgsql?

Thanks in advance,
Markus

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: plpgsql: how to use a composite type varray
Next
From: "David G. Johnston"
Date:
Subject: Re: Select values by interval