2007/9/5, Raj A <raj.ayappan@gmail.com>:
> correction:
>
> > The result I'm expecting for the above to be
> >
> > notification_time | finished_time | actual
> > ------------------------+------------------------+-----------------
> > 2007-07-06 15:50:00+10 | 2007-07-09 07:10:00+10 | 01:20:00
> > 2007-07-07 12:30:00+10 | 2007-07-09 07:20:00+10 | 00:20:00
Could you please show the data structures ( create table commmands +
ane constraints you have )?
If you do this, you have much bigger chance of getting an answer :)
--
Filip Rembiałkowski