Re: Daylight saving bug in PostgreSQL 7.2.1 ?

Dnia 07/12/2003 04:54 AM, Jonas Lindholm napisa³(a):
> 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