Alessandro Gagliardi <alessandro@xxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance