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

From Tom Lane
Subject Re: Do cast affects index usage?
Date
Msg-id 27829.1350092048@sss.pgh.pa.us
Whole thread Raw
In response to Re: Do cast affects index usage?  ("Anibal David Acosta" <aa@devshock.com>)
List pgsql-performance
"Anibal David Acosta" <aa@devshock.com> writes:
> Because I need to get all rows where datetime is greater than (for example)
> '2012-10-10 00:00:00' but ignoring timezone, so basically I need to truncate
> timezone
> This can be done by converting to timestamp without timezone.

[ shrug... ]  It can also be done without that.  Whatever your cutoff
time is can be expressed as a timestamp *with* tz.

            regards, tom lane


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: problems with large objects dump
Next
From: Stefan Keller
Date:
Subject: Index over all partitions (aka global index)?