Home > mailing lists

not exists clause - Mailing list pgsql-performance

From	S Golly
Subject	not exists clause
Date	January 10, 2008 19:16:00
Msg-id	4a5f56930801101215l5ae2d5bdk2db4f1873e0789ca@mail.gmail.com Whole thread Raw
Responses	Re: not exists clause Re: not exists clause
List	pgsql-performance

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 for your support.

From: Jared Mauch
Date: 10 January 2008, 13:35:03
Subject: Re: big database performance

From: Josh Berkus
Date: 10 January 2008, 20:47:55
Subject: Re: not exists clause