Received: from p1.selectacast.net (IDENT:root@p1.selectacast.net [206.41.1.251]) by hub.org (8.10.1/8.11.0) with ESMTP id e9HMhdW24224 for ; Tue, 17 Oct 2000 18:43:39 -0400 (EDT) (envelope-from jks@selectacast.net) Received: from selectacast.net (IDENT:jks@d1 [209.219.91.66]) by p1.selectacast.net (8.9.3/8.9.3) with ESMTP id SAA15734; Tue, 17 Oct 2000 18:43:16 -0400 Message-ID: <39ECD604.B49EC417@selectacast.net> Date: Tue, 17 Oct 2000 18:43:16 -0400 From: Joseph Shraibman Organization: Xtenit X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.15 i686) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane CC: depesz@depesz.pl, PGSQL-SQL Subject: Re: problem with select where like ']' References: <20001017210251.A4327@cyber.cs.net.pl> <1986.971811218@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/163 X-Sequence-Number: 1825 Tom Lane wrote: > > hubert depesz lubaczewski 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