Hi Ezequias,
On Fri, 2006-11-10 at 16:34 -0200, Ezequias Rodrigues da Rocha wrote:
> Ok thank you very much, but the suggestion (SQL:when field =
> '2006-09-06'::date) does not retrieve any row. It does not retrive any
> error too, but the suggestion does not applied to my requisition.
I think you want to cast the field, not the constant, e.g.,
testdb=> select * from t2 where date(tm) = '2006-9-6';
tm
-------------------------------
2006-09-06 00:00:01-04
2006-09-06 23:59:59.999999-04
(2 rows)
Joe
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
