Re: Date represetation bug. Some dates are incorrectly selected - Mailing list pgsql-bugs

pgsql-bugs@postgresql.org writes:
> test=> create table pippo (d date);
> CREATE
> test=> insert into pippo values ('22/05/1977');
> INSERT 629024 1
> test=> insert into pippo values ('28/05/1978');
> INSERT 629025 1
> test=> select * from pippo;
>     d
> ------------
>  21/05/1977
>  27/05/1978
> (2 rows)
> test=> select * from pippo where d = '22/05/1977';
>     d
> ------------
>  21/05/1977
> (1 rows)

Hm. Are these dates daylight-savings-time transition dates in your
timezone?  If so, this is probably a known bug that has been fixed
in more recent Postgres releases.  (RedHat 6.2 ships with Postgres
6.5.something if I recall correctly.  I suggest updating to PG 7.0.3.)

            regards, tom lane