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 12510D1B1D0
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 14 Jun 2004 16:12:02 -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 79943-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 14 Jun 2004 19:11:58 +0000 (GMT)
Received: from hotmail.com (bay8-f58.bay8.hotmail.com [64.4.27.58])
	by svr1.postgresql.org (Postfix) with ESMTP id B6F17D1B1CE
	for <pgsql-sql@postgresql.org>; Mon, 14 Jun 2004 16:11:55 -0300 (ADT)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Mon, 14 Jun 2004 12:11:56 -0700
Received: from 69.65.137.210 by by8fd.bay8.hotmail.msn.com with HTTP;
	Mon, 14 Jun 2004 19:11:56 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" <el_vigia_ec@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: a query with = ALL
Date: Mon, 14 Jun 2004 19:11:56 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <BAY8-F587t8oImnP6Su0000fb4d@hotmail.com>
X-OriginalArrivalTime: 14 Jun 2004 19:11:56.0996 (UTC)
	FILETIME=[760B6040:01C45243]
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/122
X-Sequence-Number: 18067

>"Jaime Casanova" <el_vigia_ec@hotmail.com> 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.

both CPA.cur_paralelo and the cur_paralelo obtained in the subquery are 
char(2) i assume there are no problem, i'm wrong?

thanx in advance,

Jaime Casanova

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. 
http://join.msn.com/?page=features/virus