Re: [SQL] index compatible date_trunc in postgres?

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

Re: [SQL] index compatible date_trunc in postgres?

Tom Lane wrote: Why are you worrying? The old method surely didn't get indexed either. Continuous improvement? Since there already IS an index available, I figure I might as well use it, especially since this DB had real performance issues. The table itself is medium sized in our world,

[SQL] index compatible date_trunc in postgres?

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

Re: [SQL] index compatible date_trunc in postgres?

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