Re: Bug in select with 'like' and index of two columns

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rp(at)ockham(dot)be, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug in select with 'like' and index of two columns
Date: 2000-11-24 17:40:27
Message-ID: 16881.975087627@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
> As you will see below - when I use index on two columns in the case
> below, a select with "like" doesn't work correctly.

This looks like a variant of the known problems with LIKE index
optimization in non-ASCII locales. What locale settings (environment
variables) are you running the postmaster with?

It would be useful to see the output of EXPLAIN VERBOSE for the
failing query, also.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2000-11-24 19:30:34 Re: installation Pb
Previous Message RAMI ZALLOUM 2000-11-24 17:39:49 installation Pb