Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 66B8B650248 for ; Fri, 1 Aug 2008 12:32:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 08961-05 for ; Fri, 1 Aug 2008 12:31:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from relais.videotron.ca (relais.videotron.ca [24.201.245.36]) by postgresql.org (Postfix) with ESMTP id D43EF650191 for ; Fri, 1 Aug 2008 12:31:51 -0300 (ADT) MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; charset=UTF-8; format=flowed Received: from [192.168.0.51] ([96.21.103.185]) by VL-MH-MR002.ip.videotron.ca (Sun Java(tm) System Messaging Server 6.3-4.01 (built Aug 3 2007; 32bit)) with ESMTP id <0K4X00JDRHT2Q7I0@VL-MH-MR002.ip.videotron.ca> for pgsql-php@postgresql.org; Fri, 01 Aug 2008 11:31:51 -0400 (EDT) Message-id: <48932C6E.9030309@videotron.ca> Date: Fri, 01 Aug 2008 11:31:58 -0400 From: PJ User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) To: Andy Shellam Cc: pgsql-php@postgresql.org Subject: Re: display query results References: <48909454.7040305@videotron.ca> <82E74D266CB9B44390D3CCE44A781ED90B64DC@POSTOFFICE.cranel.local> <4890A871.3020906@videotron.ca> <4890AA8C.9080907@spidersilk.net> <4890CA07.2040405@videotron.ca> <4890D124.7020506@mailnetwork.co.uk> <4890D6F6.40709@videotron.ca> <4890DBBC.6080404@mailnetwork.co.uk> <4890E12F.4050805@videotron.ca> <4890E297.3080405@mailnetwork.co.uk> <4891C439.6000106@videotron.ca> In-reply-to: <4891C439.6000106@videotron.ca> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/1 X-Sequence-Number: 3885 You were quite right, the problem was a line feed after the word "Alcohol" Now it works fine. Thanks, I learned a lot .... :) Andy Shellam wrote: >> Haha, no worries, I've had the same issue before. >> It's almost certain that the text in your column does not exactly >> match "Alcohol" for one of a few reasons, e.g. >> >> "Alcohol " (right-padding) >> " Alcohol" (left-padding) >> " Alcohol " (padded both sides) >> >> will not match = 'Alcohol' in the query. >> Try trimming the data in that field - from PgAdmin or some other >> query tool, run something like: >> >> |UPDATE glossary_item SET "name" = |trim(both ' ' from "name")