Re: not exists clause
От
Josh Berkus
Тема
Re: not exists clause
Дата
Msg-id
200801101350.33211.josh@agliodbs.com
Ответ на
not exists clause (S Golly)
Список
Дерево обсуждения
not exists clause "S Golly" <gollykai@gmail.com>
Re: not exists clause Josh Berkus <josh@agliodbs.com>
Re: not exists clause Guy Rouillier <guyr-ml1@burntmail.com>
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 the actual query and error message. WHERE NOT EXISTS has been supported since version 7.1. -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco
В списке pgsql-performance по дате отправления
