Select Code to Download

column Posting List ==> "10 20;3 21 2; 43 100;105;......

WORD
IN_DOCUMENT
AT_POSITION

TABLE words
    word    CHAR(32) PRIMARY KEY
...
    word_id  INT
    doc_id   INT
    pos      INT

CREATE INDEX warpspeed ON word_doc (word_id)

SELECT doc_id FROM word_doc WHERE word_id = ?
INTERSECT
SELECT doc_id FROM word_doc WHERE word_id = ?