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

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

pgsql-sql by date

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

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