Re: [PERFORM] not exists clause

S Golly wrote: I cannot get the "not exists" clause of ANSI SQL to execute correctly. select t.col11, t.col1... from table1 t where not exists (select 1 from table2 where col2 = t.col1); table1 has 40M + rows. if that matters. OS is FreeBSD 6.2, postgresql version 8.2.6 Is it not supported

Re: [PERFORM] not exists clause

Golly, > I cannot get the "not exists" clause of ANSI SQL to execute correctly. > select t.col11, t.col1... from table1 t where not exists (select 1 from > table2 where col2 = t.col1); > table1 has 40M + rows. if that matters. > > OS is FreeBSD 6.2, postgresql version 8.2.6 You'll have to post th

[PERFORM] not exists clause

I cannot get the "not exists" clause of ANSI SQL to execute correctly. select t.col11, t.col1... from table1 t where not exists (select 1 from table2 where col2 = t.col1); table1 has 40M + rows. if that matters. OS is FreeBSD 6.2, postgresql version 8.2.6 Is it not supported or a bug ? thank you