Re: Data comparison SQL in PG 8.2.9

2009/1/12 Thomas Markus <t.markus@proventis.net>:
> be sure to use correct data types. I suppose psql uses timestamps so
>
> select id from users where modify_date = '2009-01-08' limit 1;
>
> is converted to
>
> select id from users where modify_date = '2009-01-08 00:00:00'::timestamp
> limit 1;
>
>
> try
>
> select id from users where modify_date::date = '2009-01-08'::date limit 1;




Thanks. But it used to work without this, and more importantly, this
doesn't explain why the ">" queries are so exceedingly slow now! Any
thoughts?