Re: timestamp with time zone - Mailing list pgsql-performance

Alessandro Gagliardi <alessandro@path.com> wrote:

> (Actually, I originally did try one on "(created at time zone
> timezone)::date" but couldn't figure out how to phrase it in a way
> PostgreSQL would accept.)

CREATE INDEX blocks_created_date_idx
  ON blocks
  USING btree
  (((created at time zone timezone)::date));

-Kevin