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