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
Message-ID: <BAY8-F587t8oImnP6Su0000fb4d@hotmail.com> (raw)
>"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: el_vigia_ec@hotmail.com
Subject: Re: a query with = ALL
In-Reply-To: <BAY8-F587t8oImnP6Su0000fb4d@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox