2007/9/5, Raj A <raj.ayappan@xxxxxxxxx>:> 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 ---------------------------(end of broadcast)---------------------------TIP 6: explain analyze is your friend
