"Net Virtual Mailing Lists" <mailinglists(at)net-virtual(dot)com>(by way of Net Virtual Mailing Lists <mailinglists(at)net-virtual(dot)com>) writes:
> >SELECT * from sometable WHERE category1 IS NOT NULL
> > AND data_fti @@ to_tsquery('default', 'postgres');
What you can do is a partial index:
create index fulltextindex on sometable (...) WHERE category1 IS NOT NULL
This is even better than the is_null() index because it will still be able to
do the full text search. However note that having three entire full text
indexes is going to consume a lot of space and incur a lot of disk i/o
overhead to maintain.
--
greg