Re: index compatible date_trunc in postgres?

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Bryce Nesbitt <bryce2(at)obviously(dot)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