Re: need to join successive log entries into one - Mailing list pgsql-sql

On Wed, Mar 14, 2001 at 09:17:33PM +0000, Richard H wrote:
> 
> > I need to produce a new table that coalesces immediately successive
> > operations on a run into one, e.g.:
> 
> > run   |  start               | done
> >   1415|  2001-01-29 12:36:55| 2001-02-07 13:02:38
> >   1415|  2001-02-14 07:40:04|
> >   1747|  2001-02-15 09:14:39| 2001-03-01 09:02:39
> >   1747|  2001-03-05 13:13:58|
> >   1954|  2001-02-02 20:55:39| 2001-03-02 10:17:15
> 
> Try:
> 
> select run,min(start),max(done) from mytable group by run;
select run,min(start),max(done) from mytable group by runUNION ALLselect run,start,NULL from mytable where done is
null;

Assuming that any given run has only one open step.

Ross