Re: [SQL] a query with = ALL

2004-06-14 Thread Jaime Casanova
"Jaime Casanova" <[EMAIL PROTECTED]> 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

Re: [SQL] a query with = ALL

2004-06-14 Thread Tom Lane
"Jaime Casanova" <[EMAIL PROTECTED]> 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 y

[SQL] a query with = ALL

2004-06-14 Thread Jaime Casanova
Hi all, some more info a think can be useful to probe there is somting wrong. I pointed that the query select cur_paralelo from rec_m_cuadropagos WHERE ent_codigo = 1 AND sec_codigo = 1 AND