Re: [PERFORM] using like in a prepare doesnt' use the right index

2008-03-28 Thread Gavin Sherry
On Thu, Mar 27, 2008 at 03:14:49PM -0400, Dave Cramer wrote: > I have a query which is > > prepare s_18 as select uid from user_profile where name like > $1::varchar and isactive=$2 order by name asc limit 250; > > explain analyze execute s_18 ('atxchery%','t'); >

[PERFORM] using like in a prepare doesnt' use the right index

2008-03-27 Thread Dave Cramer
I have a query which is prepare s_18 as select uid from user_profile where name like $1::varchar and isactive=$2 order by name asc limit 250; explain analyze execute s_18 ('atxchery%','t'); QUERY PLAN --