Thread

Re: [HACKERS] SELECT BUG

Jose Soares <jose@sferacarta.com> — 1999-09-03T12:28:54Z

And now the other SELECT bug in the same data:

select master1.*, detail1.*
from master1 m, detail1 d
where trim(m.code)=trim(d.code);

(I know there's an error in this syntax, but I don't know why PostgreSQL
finds it good and execute a strange query)

code       |code1           |code
-----------+----------------+----------------
a          |a               |a13
a1         |a1              |a13
a13        |a13             |a13
a          |a               |a1
a1         |a1              |a1
a13        |a13             |a1
a          |a               |a13
a1         |a1              |a13
a13        |a13             |a13
a          |a               |a13
a1         |a1              |a13
a13        |a13             |a13
a          |a               |a1
a1         |a1              |a1
a13        |a13             |a1
a          |a               |a13
a1         |a1              |a13
a13        |a13             |a13
a          |a               |a13
a1         |a1              |a13
a13        |a13             |a13
a          |a               |a1
a1         |a1              |a1
a13        |a13             |a1
a          |a               |a13
a1         |a1              |a13
a13        |a13             |a13
(27 rows)

Any idea ?

José