Roundup Tracker - Issues

Message3615

Author ajaksu2
Recipients ajaksu2, cknittel, richard
Date 2009-03-01.20:45:14
Message-id <1235940314.83.0.133077152514.issue1155657@psf.upfronthosting.co.za>
In-reply-to
Hm, I get this working with postgresql by hacking indexer_rdbms.py so
that it first finds issues containing each of the words, then intersects
that.

Here's some example generated SQL for AND'ing at issue level, if it's
too stupid please enlighten me :) :

select nodeid from issue_messages where linkid in (
select CAST(_itemid as Integer) from __textids where _textid in (
select distinct(_textid) from __words where _word=E'NICE')) INTERSECT
 select nodeid from issue_messages where 
linkid in (
select CAST(_itemid as Integer) from __textids where _textid in (
select distinct(_textid) from __words where _word=E'TWO'));
History
Date User Action Args
2009-03-01 20:45:14ajaksu2setmessageid: <1235940314.83.0.133077152514.issue1155657@psf.upfronthosting.co.za>
2009-03-01 20:45:14ajaksu2setrecipients: + ajaksu2, richard, cknittel
2009-03-01 20:45:14ajaksu2linkissue1155657 messages
2009-03-01 20:45:14ajaksu2create