Received: from elca.ch (mail.elca.ch [194.191.157.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAH99gs31718 for ; Fri, 17 Nov 2000 04:09:42 -0500 (EST) (envelope-from yma@elca.ch) Received: from exchange.elca.ch by elca.ch (8.8.8/SMI-SVR4) id KAA18186; Fri, 17 Nov 2000 10:01:43 +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 W5DQKZN6; Fri, 17 Nov 2000 10:08:15 +0100 From: Yves Martin Organization: ELCA To: pgsql-sql@postgresql.org Subject: Like seems to fail ! Date: Fri, 17 Nov 2000 09:58:23 +0100 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <00111710092402.00703@pcyma.elca.ch> Content-Transfer-Encoding: 8bit X-Archive-Number: 200011/132 X-Sequence-Number: 163 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