Scott Marlowe escribió: > On Thu, Dec 18, 2008 at 10:46 PM, Bryce Nesbitt <bry...@obviously.com> wrote: > > I've got a legacy app that does 8.3 incompatible date searches like so: > > explain select count(*) from contexts where publication_date like '2006%'; > > explain select count(*) from contexts where publication_date like > > '2006-09%';
> You can create an index on date_trunc (on timestamp without timezone, > but not on timestamp with timezone since it's not immutable) But you can create an index on the timestamptz AT TIME ZONE 'GMT', I think. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
