Received: from sivka.carrier.kiev.ua (root@sivka.carrier.kiev.ua [193.193.193.101]) by hub.org (8.10.1/8.11.0) with ESMTP id e9HKDOW40367 for ; Tue, 17 Oct 2000 16:13:25 -0400 (EDT) (envelope-from evpopkov@carrier.kiev.ua) Received: from planka.carrier.kiev.ua (root@users.lucky.net [193.193.193.106]) by sivka.carrier.kiev.ua (8/Kilkenny_is_better) with ESMTP id XFD06621 for ; Tue, 17 Oct 2000 23:13:20 +0300 (EEST) (envelope-from evpopkov@carrier.kiev.ua) Received: from ed.ed (ln2-51.users.lucky.net [193.193.199.51]) by planka.carrier.kiev.ua (8) with ESMTP id XFD08658 for ; Tue, 17 Oct 2000 23:13:18 +0300 (EEST) (envelope-from evpopkov@carrier.kiev.ua) Received: (from root@localhost) by ed.ed (8.8.7/8.8.5) id UAA00314 for pgsql-sql@postgresql.org; Tue, 17 Oct 2000 20:07:30 GMT From: KuroiNeko Date: Tue, 17 Oct 2000 20:07:29 +0000 To: pgsql-sql@postgresql.org Subject: Re: problem with select where like ']' Message-ID: <39ECB181.nail8J114GAI@ed.ed> References: <20001017210251.A4327@cyber.cs.net.pl> <1986.971811218@sss.pgh.pa.us> User-Agent: nail 9.14 2000-06-26 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/160 X-Sequence-Number: 1822 > 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. OTOH, it seems like it shouldn't return any rows, as the original statement has no metacharachters, % or _ -- Well I tried to be meek And I have tried to be mild But I spat like a woman And I sulked like a child I have lived behind the walls That have made me alone Striven for peace Which I never have known Dire Straits, Brothers In Arms, The Man's Too Strong (Knopfler)