Re: select like...not using index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, "PgSql-Win32" <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: select like...not using index
Date: 2004-05-29 04:35:27
Message-ID: 14637.1085805327@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-hackers-win32

"Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> writes:
> Sometime between yesterday and today queries in the form of
> "select * from t where t.f like 'k%'" have been broken so that they
> never use the index (on win32, not sure about others).

Not here ... and I've seen no commits that I'd have thought would affect
that. Check for local configuration changes.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2004-05-29 05:11:18 Re: Extended customizing, SQL functions,
Previous Message Tom Lane 2004-05-29 04:20:07 Re: temp tables broken in CVS HEAD?

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Thomas Swan 2004-05-29 05:01:42 Re: could not locate my own executable path
Previous Message Bruce Momjian 2004-05-29 03:12:00 Re: nested transaction patch build?