| From: | José Soares <jose(at)sferacarta(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] SELECT BUG |
| Date: | 1999-09-03 12:28:54 |
| Message-ID: | 37CFBF06.F6DACB81@sferacarta.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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é
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-09-03 14:46:48 | Re: [HACKERS] md.c is feeling much better now, thank you |
| Previous Message | The Hermit Hacker | 1999-09-03 11:19:07 | Re: [HACKERS] Re: University Masters Project |