Ramiro Arenas R <[EMAIL PROTECTED]> writes:
> I have a column x in a table of type date and i have an index on x
> runing the query "SELECT * FROM table WHERE x >= '2004-01-01"
> i get this:
> Unable to convert date to tm
AFAICT, that error message hasn't existed in PG since 7.1. If you
are running 7.1.* or older, I'd suggest an update. The particular
issue here seems to be that 7.1 does not contain a workaround for
broken mktime() library routines that reject dates before 1970.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
