hmm...ok...planner is not using the index effectively (as effectively as when a non-empty value is passed in)
--- On Fri, 11/27/09, Tom Lane <[email protected]> wrote: > From: Tom Lane <[email protected]> > Subject: Re: [GENERAL] empty string causes planner to avoid index. Makes me > sad. > To: "Jeff Amiel" <[email protected]> > Cc: [email protected] > Date: Friday, November 27, 2009, 3:14 PM > Jeff Amiel <[email protected]> > writes: > > It appears that somehow the empty string is causing > the planner to abandon the index. > > You didn't actually show us such a case... > > > regards, tom lane > -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
