On 16.09.2011 12:59, Marc Mamin wrote:
This is not valid, but is accepted.
EXPLAIN analyze
select * from test_f_files_steps where id in
(select id from
(
select file_id,class_id from test_f_files_steps
EXCEPT
select id,class_id from test_f_files_status
)foo
)
It is
The following bug has been logged online:
Bug reference: 6209
Logged by: Marc Mamin
Email address: m...@intershop.de
PostgreSQL version: 9.1beta3
Operating system: Linux
Description:Invalid subquery is accepted within a IN() clause
Details:
Hello,
This is somehow s