ageev_at_mail.cir.ru (Misha Ageev) wrote in message news:<877c3c6c.0307170517.6841e6e0_at_posting.google.com>...
> Such index allow to quickly run queries like
> (
> (SELECT feat_id FROM ma14_doc_feats dfi WHERE doc_id=1
> INTERSECT
> SELECT feat_id FROM ma14_doc_feats dfi WHERE doc_id=2
> )
> MINUS
> SELECT feat_id FROM ma14_doc_feats dfi WHERE doc_id=3
> )
> UNION
> SELECT feat_id FROM ma14_doc_feats dfi WHERE doc_id=4
>
Hmm... You sure this is the query you want?
Received on Thu Jul 17 2003 - 13:55:47 CDT
