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 <tgl@xxxxxxxxxxxxx> wrote: > From: Tom Lane <tgl@xxxxxxxxxxxxx> > Subject: Re: empty string causes planner to avoid index. Makes me sad. > To: "Jeff Amiel" <becauseimjeff@xxxxxxxxx> > Cc: pgsql-general@xxxxxxxxxxxxxx > Date: Friday, November 27, 2009, 3:14 PM > Jeff Amiel <becauseimjeff@xxxxxxxxx> > 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
