Unable to convert date to tm - Mailing list pgsql-sql

From Ramiro Arenas R
Subject Unable to convert date to tm
Date
Msg-id 1076445948.5346.12.camel@maxims.coordinadora.com
Whole thread Raw
Responses Re: Unable to convert date to tm  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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 index.

Thanks in advance.







pgsql-sql by date:

Previous
From: "Greg Patnude"
Date:
Subject: Re: Unique Constraint with foreign Key
Next
From: stermic@gw.co.jackson.mo.us (Michael Sterling)
Date:
Subject: max timestamp