2007/9/5, Raj A <[EMAIL PROTECTED]>: > 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
