Re: parameterized LIKE does not use index

Bruno,

> I remember some discussion about delaying planning until the first
> actual query so that planning could use actual parameters to do
> the planning. If you really want to have it check the parameters
> every time, I think you will need to replan every time. I don't
> know if there is a way to save some of the prepare working while
> doing this.

That wouldn't help much in Kurt's case.    Nor in most "real" cases, which is
why I think the idea never went anywhere.

--
Josh Berkus
Aglio Database Solutions
San Francisco