Re: timestamp with time zone

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Alessandro Gagliardi" <alessandro(at)path(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: timestamp with time zone
Date: 2012-02-09 20:15:26
Message-ID: 4F33D4FE0200002500045139@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Alessandro Gagliardi <alessandro(at)path(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alessandro Gagliardi 2012-02-09 20:38:22 Re: timestamp with time zone
Previous Message Alessandro Gagliardi 2012-02-09 20:00:56 Re: timestamp with time zone