The following bug has been logged online:
Bug reference: 1682
Logged by: D.J. Kniep
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Linux
Description: subselect generates multiple rows
Details:
table1:
id content
1 John Doe
2 Peter Gabriel
view2
id extra1 extra2
1 a1 b1
1 a1 b1
2 a1 b3
3 a1 b5
query:
select * from table1 t1 where t1.id in (select t2.id from view2 t2 where
extra1 = 'a1')
produces:
id content
1 John Doe
1 John Doe
2 Peter Gabriel
which obviously should be:
id content
1 John Doe
2 Peter Gabriel
I might not be reachable on my mailaddress because of US imposed
restrictions. A big range of the IP addresses of the provider I am using are
marked as spam generating (which in fact is NOT true at least not for my IP
address), and blacklisted and this makes it effectively impossible for me to
use the mailinglist.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
