Re: [SQL] Unable to convert date to tm

2004-02-15 Thread Tom Lane
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 run

[SQL] Unable to convert date to tm

2004-02-15 Thread Ramiro Arenas R
Hi 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 where using a cast like this: "SELECT * FROM table WHERE x >='2004-01-01::timestamp" result is ok but it doesn't use in