Re: problem with select where like ']'

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: depesz(at)depesz(dot)pl, PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: problem with select where like ']'
Date: 2000-10-17 22:43:16
Message-ID: 39ECD604.B49EC417@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tom Lane wrote:
>
> hubert depesz lubaczewski <depesz(at)depesz(dot)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(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-10-17 23:29:21 Re: problem with select where like ']'
Previous Message John Hasler 2000-10-17 22:25:19 Re: nested transactions