pgsql-bugs(at)postgresql(dot)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