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 5857FD1B1CE for ; Mon, 14 Jun 2004 15:02:43 -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 44112-08 for ; Mon, 14 Jun 2004 18:02:07 +0000 (GMT) Received: from hotmail.com (bay8-f95.bay8.hotmail.com [64.4.27.95]) by svr1.postgresql.org (Postfix) with ESMTP id 2BAA7D1B19B for ; Mon, 14 Jun 2004 15:01:32 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 14 Jun 2004 11:01:26 -0700 Received: from 69.65.137.210 by by8fd.bay8.hotmail.msn.com with HTTP; Mon, 14 Jun 2004 18:01:26 GMT X-Originating-IP: [69.65.137.210] X-Originating-Email: [el_vigia_ec@hotmail.com] X-Sender: el_vigia_ec@hotmail.com From: "Jaime Casanova" To: pgsql-sql@postgresql.org Subject: Re: query with =ALL Date: Mon, 14 Jun 2004 18:01:26 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 14 Jun 2004 18:01:26.0344 (UTC) FILETIME=[9C611C80:01C45239] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=NO_DNS_FOR_FROM X-Spam-Level: * X-Archive-Number: 200406/114 X-Sequence-Number: 18059 >Jaime Casanova wrote: >>Hi all, >> >>i have an strange result here, i'm using 7.4.2 on redhat 8 >> >>i have a query like this > >[snip] > >>this query proves that its result is 'A', 'B', 'C' >>any idea, is something wrong in my thinking? >Do you have any null values involved? That might well interfere (though I >admit I haven't looked in >detail) There are no null values here, i'm sure of that because all the fields in the subquery included the one i'm returning are part of the PK >-- > Richard Huxton > Archonet Ltd and when i do the selects individually i got the correct results SELECT CPA.rub_codigo, RUB.rub_descripcion, CPA.cpa_valor, CPA.cpa_fechavencimiento FROM rec_m_cuadropagos CPA, rec_m_rubro RUB WHERE RUB.ent_codigo = CPA.ent_codigo AND RUB.rub_codigo = CPA.rub_codigo AND CPA.ent_codigo = 1 AND CPA.sec_codigo = 1 AND CPA.ani_codigo = '2004-2005' AND CPA.cic_codigo = 1 AND CPA.esp_codigo = 0 AND CPA.cur_codigo = 1 AND CPA.cur_paralelo = 'A ' 1 Matrícula 100 05/10/2005 SELECT CPA.rub_codigo, RUB.rub_descripcion, CPA.cpa_valor, CPA.cpa_fechavencimiento FROM rec_m_cuadropagos CPA, rec_m_rubro RUB WHERE RUB.ent_codigo = CPA.ent_codigo AND RUB.rub_codigo = CPA.rub_codigo AND CPA.ent_codigo = 1 AND CPA.sec_codigo = 1 AND CPA.ani_codigo = '2004-2005' AND CPA.cic_codigo = 1 AND CPA.esp_codigo = 0 AND CPA.cur_codigo = 1 AND CPA.cur_paralelo = 'B ' 1 Matrícula 100 05/10/2005 SELECT CPA.rub_codigo, RUB.rub_descripcion, CPA.cpa_valor, CPA.cpa_fechavencimiento FROM rec_m_cuadropagos CPA, rec_m_rubro RUB WHERE RUB.ent_codigo = CPA.ent_codigo AND RUB.rub_codigo = CPA.rub_codigo AND CPA.ent_codigo = 1 AND CPA.sec_codigo = 1 AND CPA.ani_codigo = '2004-2005' AND CPA.cic_codigo = 1 AND CPA.esp_codigo = 0 AND CPA.cur_codigo = 1 AND CPA.cur_paralelo = 'C ' 1 Matrícula 100 05/10/2005 _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail