Unable to convert date to tm

From: Ramiro Arenas R <ramiroa(at)coordinadora(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Unable to convert date to tm
Date: 2004-02-10 20:45:49
Message-ID: 1076445948.5346.12.camel@maxims.coordinadora.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David B 2004-02-11 01:18:46 Elegant way to monitor for changes in a trigger and migrate record to history table
Previous Message Bruno Wolff III 2004-02-10 20:15:21 Re: Unique Constraint with foreign Key