i just had this thought.
i should take both dates, subtract them and multiply the figure by 24.
then i should insert that many rows with their individual timestamps
into the table in a sequential order.
eg 2005-12-12 12:00:00
2005-12-13 01:00:00 and so on.
can somebody please guide me in this.
thanks.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
