Dear friends,
I have this table
table work{
day date,
hour integer,
}
select * from work;
date | text
-----------
1-1-2003 1
1-1-2003 1
2-1-2003 5
3-1-2003 10
5-1-2003 15
how can i obtain this?
date | text
-----------
1-1-2003 2
2-1-2003 5
3-1-2003 10
4-1-2003 null
5-1-2003 15
6-1-2003 null