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@sss.pgh.pa.us> wrote:
> From: Tom Lane <tgl@sss.pgh.pa.us>
> Subject: Re: [GENERAL] empty string causes planner to avoid index. Makes me sad.
> To: "Jeff Amiel" <becauseimjeff@yahoo.com>
> Cc: pgsql-general@postgresql.org
> Date: Friday, November 27, 2009, 3:14 PM
> Jeff Amiel <becauseimjeff@yahoo.com>
> 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
>