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

On Fri, Oct 12, 2012 at 2:05 PM, Anibal David Acosta <aa@devshock.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));