<>(not equal to) in where clause can use index
Started by AI Rummanabout 15 years ago2 messagesgeneral
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.
Re: <>(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
/Nicklas
Show quoted text
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.