Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2000-11-24 19:30:34
Subject: Re: installation Pb
Previous:From: RAMI ZALLOUMDate: 2000-11-24 17:39:49
Subject: installation Pb

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group