X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B50029DC812 for ; Thu, 5 Jan 2006 10:44:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95081-01 for ; Thu, 5 Jan 2006 10:44:49 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 551169DC853 for ; Thu, 5 Jan 2006 10:44:42 -0400 (AST) Received: from bitoek.uni-bayreuth.de (bti0x1.bitoek.uni-bayreuth.de [132.180.112.2]) by svr4.postgresql.org (Postfix) with ESMTP id 2D1155AF06D for ; Thu, 5 Jan 2006 14:44:46 +0000 (GMT) Received: from [132.180.112.27] (bti0x027.bitoek.uni-bayreuth.de [132.180.112.27]) by bitoek.uni-bayreuth.de (8.13.3/8.12.7) with ESMTP id k05EibCu016741 for ; Thu, 5 Jan 2006 15:44:37 +0100 Message-ID: <43BD30D4.1030202@bayceer.uni-bayreuth.de> Date: Thu, 05 Jan 2006 15:44:36 +0100 From: Stefan Holzheu User-Agent: Mozilla/5.0 (X11; U; Linux i686; de-AT; rv:1.7.12) Gecko/20050921 X-Accept-Language: de, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: like vs = X-Enigmail-Version: 0.90.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200601/133 X-Sequence-Number: 20221 Hallo, I just encountered a stange behaviour: The following query gives zero rows. bitoek=> SELECT name from file where name = 'mitarbeiter/mit/mitarbeiter_ehemalig.php'; name ------ (0 Zeilen) Replacing "=" by like and escaping the underscore gives the row I knew to be there: bitoek=> SELECT name from file where name like 'mitarbeiter/mit/mitarbeiter\_ehemalig.php'; name ------------------------------------------ mitarbeiter/mit/mitarbeiter_ehemalig.php (1 Zeile) Other queries with the equal operator do match rows. Am I missing something? Postgresql: 8.1.1 Fieldtype: text Database encoding: Latin9 Regards, Stefan -- ----------------------------- Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5709 BayCEER EDV und Datenbanken Universitaet Bayreuth D-95440 Bayreuth -----------------------------