<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>