Alessandro Gagliardi <alessan...@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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to