Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAKFv5s24273 for ; Mon, 20 Nov 2000 10:57:05 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id eAKFrmw27822; Mon, 20 Nov 2000 10:53:48 -0500 (EST) To: Yves Martin cc: sqllist Subject: Re: Like seems to fail ! In-reply-to: <00112008291300.01625@pcyma.elca.ch> References: <00112008291300.01625@pcyma.elca.ch> Comments: In-reply-to Yves Martin message dated "Mon, 20 Nov 2000 08:28:03 +0100" Date: Mon, 20 Nov 2000 10:53:48 -0500 Message-ID: <27819.974735628@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200011/155 X-Sequence-Number: 186 Yves Martin writes: > base=# select * from persistent_config where key like '/%'; > key | type | value > -----+------+------- > (0 rows) What LOCALE are you running in? There are some known problems with LIKE index optimization in some non-ASCII locales. If you drop the index on persistent_config.key, does the problem disappear? regards, tom lane