Flatten table using timestamp and source
От | Elrich Marx |
---|---|
Тема | Flatten table using timestamp and source |
Дата | |
Msg-id | 73a6b75b83b37093e5e2751fc59c4323@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Flatten table using timestamp and source
|
Список | pgsql-sql |
<div class="WordSection1"><p class="MsoNormal">Good day.<p class="MsoNormal"> <p class="MsoNormal">I am quite new to Postgres,so please bear with me.<p class="MsoNormal"> <p class="MsoNormal">I have a table with data in the following format:<pclass="MsoNormal"> <p class="MsoNormal">Table name : Time_Source_Table<p class="MsoNormal">Source , Stime<p class="MsoNormal">1,"2012-05-24 13:00:00"<p class="MsoNormal">1, "2012-05-24 13:01:00"<p class="MsoNormal">1, "2012-05-2413:02:00"<p class="MsoNormal">2, "2012-05-24 13:03:00"<p class="MsoNormal">2, "2012-05-24 13:04:00"<p class="MsoNormal">1,"2012-05-24 13:05:00"<p class="MsoNormal">1, "2012-05-24 13:06:00"<p class="MsoNormal"> <p class="MsoNormal">I’m trying to get to a result that flattens the results based on source, to look like this:<p class="MsoNormal">Source,Stime, Etime<p class="MsoNormal">1, "2012-05-24 13:00:00","2012-05-24 13:02:00"<p class="MsoNormal">2,"2012-05-24 13:03:00","2012-05-24 13:04:00"<p class="MsoNormal">1, "2012-05-24 13:05:00","2012-05-2413:06:00"<p class="MsoNormal"> <p class="MsoNormal"> Where Etime is the last Stime for the same source.<pclass="MsoNormal"> <p class="MsoNormal">Any suggestions would be much appreciated.<p class="MsoNormal"> <p class="MsoNormal">Regards<pclass="MsoNormal"> El</div>
В списке pgsql-sql по дате отправления: