Re: [GENERAL] <>(not equal to) in where clause can use index

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

[GENERAL] <>(not equal to) in where clause can use index

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.