Received: from elca.ch ([194.191.157.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAK7Tls07603 for ; Mon, 20 Nov 2000 02:29:49 -0500 (EST) (envelope-from yma@elca.ch) Received: from exchange.elca.ch by elca.ch (8.8.8/SMI-SVR4) id IAA03823; Mon, 20 Nov 2000 08:21:23 +0100 (MET) Received: from pcyma.elca.ch ([193.72.145.112]) by exchange.elca.ch with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id W5DQK6QC; Mon, 20 Nov 2000 08:28:10 +0100 From: Yves Martin Organization: ELCA To: sqllist Subject: Like seems to fail ! Date: Mon, 20 Nov 2000 08:28:03 +0100 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <00112008291300.01625@pcyma.elca.ch> Content-Transfer-Encoding: 8bit X-Archive-Number: 200011/150 X-Sequence-Number: 181 Hello, I have a strange problem with 'like' behaviour when I upgrade from 6.5 to 7.0 Here is my table : create table persistent_config ( key varchar primary key, type varchar(12), value varchar not null ) and its content : base=# select * from persistent_config; key | type | value ------------+------+-------------- /test/info | | avalue /try/info | | avalue /test/key | | changedvalue (3 rows) And I try this 'like' command in psql : base=# select * from persistent_config where key like '/test%'; key | type | value ------------+------+-------------- /test/info | | avalue /test/key | | changedvalue (2 rows) Result is ok ! By now, this other one : base=# select * from persistent_config where key like '/%'; key | type | value -----+------+------- (0 rows) There is really something wrong ! All current content should have been returned. Is '/' caracter a new 'escape' caracter since version 6.5 In fact, my query was working well on postgresql 6.5 and since I upgraded to 7.0, this simple command failed. Is it a bug, or I missed something ? Regards, -- Yves Martin yma, Lausanne