Do cast affects index usage? - Mailing list pgsql-performance

From Anibal David Acosta
Subject Do cast affects index usage?
Date
Msg-id 004301cda8b4$fdc57bd0$f9507370$@devshock.com
Whole thread Raw
Responses Re: Do cast affects index usage?  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Do cast affects index usage?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance

I have a table with a column of type timestamp with time zone, this column has an index

 

If I do a select like this

 

select * from mytable where cast(my_date as timestamp without time zone) > '2012-10-12 20:00:00'

 

this query will use the index over the my_date column?

 

Thanks

 

pgsql-performance by date:

Previous
From: Korisk
Date:
Subject: Re: hash aggregation
Next
From: Scott Marlowe
Date:
Subject: Re: Do cast affects index usage?