Select values by interval

From: "Markus Wolters" <MarkusWolters(at)gmx(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Select values by interval
Date: 2015-11-23 16:37:42
Message-ID: trinity-9d150dc2-4428-4d05-a7a8-9ab52fcef606-1448296662813@3capp-gmx-bs03
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2015-11-23 16:49:06 Re: Select values by interval
Previous Message Tom Lane 2015-11-19 15:10:35 Re: plpgsql: how to use a composite type varray