> > select * from testdate where field1 between '2000-10-01' and
> > '2000-11-30' ;
> >
> > field1
> > ------------
> > 2000-09-30 <---- why is it here??
> > 2000-10-20
> > 2000-11-25
>
> It works fine for me (7.0.3, Debian GNU/Linux "unstable").
>
> I suspect your problem has to do with the "DATESTYLE" setting you're using;
> does it help if you do "SET DATESTYLE TO 'ISO'" prior to INSERTing your test
> values?
Just reporting, I´ve tried: \set DATESTYLE ´ISO´ before adding values, but the
result is still wrong.
Thanks anyway,
--
Renato
Sao Paulo - SP - Brasil
[EMAIL PROTECTED]
