<tt>And now the other SELECT bug in the same data:</tt><tt></tt><p><tt>select master1.*, detail1.*</tt><br /><tt>from
master1m, detail1 d</tt><br /><tt>where trim(m.code)=trim(d.code);</tt><tt></tt><p><tt>(I know there's an error in this
syntax,but I don't know why PostgreSQL</tt><br /><tt>finds it good and execute a strange
query)</tt><tt></tt><p><tt>code |code1 |code</tt><br
/><tt>-----------+----------------+----------------</tt><br/><tt>a |a |a13</tt><br
/><tt>a1 |a1 |a13</tt><br /><tt>a13 |a13 |a13</tt><br /><tt>a
|a |a1</tt><br /><tt>a1 |a1 |a1</tt><br /><tt>a13 |a13 |a1</tt><br
/><tt>a |a |a13</tt><br /><tt>a1 |a1 |a13</tt><br /><tt>a13
|a13 |a13</tt><br /><tt>a |a |a13</tt><br /><tt>a1 |a1
|a13</tt><br/><tt>a13 |a13 |a13</tt><br /><tt>a |a |a1</tt><br
/><tt>a1 |a1 |a1</tt><br /><tt>a13 |a13 |a1</tt><br /><tt>a
|a |a13</tt><br /><tt>a1 |a1 |a13</tt><br /><tt>a13 |a13
|a13</tt><br/><tt>a |a |a13</tt><br /><tt>a1 |a1 |a13</tt><br
/><tt>a13 |a13 |a13</tt><br /><tt>a |a |a1</tt><br /><tt>a1
|a1 |a1</tt><br /><tt>a13 |a13 |a1</tt><br /><tt>a |a
|a13</tt><br/><tt>a1 |a1 |a13</tt><br /><tt>a13 |a13 |a13</tt><br /><tt>(27
rows)</tt><p>Anyidea ? <p>José <br />