Bryce Nesbitt <bry...@obviously.com> writes: > 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%';
> I've got my choice of refactoring, but all these share the same > sequential scan limitation: Why are you worrying? The old method surely didn't get indexed either. (At least, it didn't unless you had an index on publication_date::text, in which case just throwing in the cast will produce the same results in 8.3.) regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql