Re: [BUGS] BUG #6209: Invalid subquery is accepted within a IN() clause

2011-09-16 Thread Heikki Linnakangas
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

[BUGS] BUG #6209: Invalid subquery is accepted within a IN() clause

2011-09-16 Thread Marc Mamin
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