Re: Do cast affects index usage?

On Fri, Oct 12, 2012 at 2:05 PM, Anibal David Acosta <aa(at)devshock(dot)com> wrote:
> 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?

No. but it will use a functional index:

create index yada on blah (cast(my_date as timestaqmp without time zone));