One way to get around the problem is often to do a left or right join, use = instead of <> , and catch the rows with null in id field, something like:
SELECT a.* from table a LEFT JOIN tableb b on a.testfld=b.testfld WHERE b.id is null; This one will use indexes on testflda and testfldb an HTH /Nicklas On Tue, 2011-02-08 at 15:09 +0600, AI Rumman wrote: > Is it possible to add some operator class in Postgresql 9 so that > <>(not equal to) in where clause can use index? > > If yes how? > > Any idea please. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
