X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2CFE0D1B48C for ; Mon, 14 Jun 2004 15:51:56 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 70127-01 for ; Mon, 14 Jun 2004 18:51:52 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id A767FD1B356 for ; Mon, 14 Jun 2004 15:51:50 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i5EIpo3a005260; Mon, 14 Jun 2004 14:51:50 -0400 (EDT) To: "Jaime Casanova" Cc: pgsql-sql@postgresql.org Subject: Re: a query with = ALL In-reply-to: References: Comments: In-reply-to "Jaime Casanova" message dated "Mon, 14 Jun 2004 17:06:05 -0000" Date: Mon, 14 Jun 2004 14:51:49 -0400 Message-ID: <5259.1087239109@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/119 X-Sequence-Number: 18064 "Jaime Casanova" writes: > brings 'A ', 'B ', 'C ' well when i cHange the real query Given that you spelled it like that, I wonder whether you aren't confused about the behavior of cross-data-type comparisons. If one column is char(n) and the other is text or varchar(n) then you may get results you didn't expect. These types have different ideas about whether trailing blanks are significant or not. regards, tom lane