Re: problem with select where like ']' - Mailing list pgsql-sql

From Joseph Shraibman
Subject Re: problem with select where like ']'
Date
Msg-id 39ECD604.B49EC417@selectacast.net
Whole thread Raw
In response to problem with select where like ']'  (hubert depesz lubaczewski <depesz@depesz.pl>)
Responses Re: problem with select where like ']'
List pgsql-sql
Tom Lane wrote:
> 
> hubert depesz lubaczewski <depesz@depesz.pl> writes:
> > but i'm just wondering why like ']' doesn't work.
> 
> What LOCALE setting are you running the postmaster in?
> 
> ']' is not a special character as far as LIKE is concerned, but
> I suspect you may be seeing another variant of the problems that
> LIKE index optimization has with peculiar collation rules.
> You can find plenty of discussion of this in the mailing list archives
> :-(
> 

WHAT mailing list archives?

They aren't linked to anywhere on www.postgresql.org that I can find.

-- 
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com


pgsql-sql by date:

Previous
From: John Hasler
Date:
Subject: Re: nested transactions
Next
From: Tom Lane
Date:
Subject: Re: problem with select where like ']'