Hi!
I believe I've found a bug with daylight saving time.
The example below shows that after inserting a row with a date and time when daylight saving is changing (6 April 2003 02:00:00) any selects using the same time and date are only returning correct result first time. If the select is done again the row is not found.
Hi,
I had similar problem that select returned 1 or 0 rows (with the same query) (if you want - see "SELECT bug?")
I don't know where is the problem, but try to reindex table timespan. In my database it resolved all problems (hope so ;) ) Now select return correct values.
Jacek
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
