Re: Iterating through SQL table

[Peter Brawley]

> hashvalue (int, Primary Key) | DocIDs (text) | count (int)
>DocIDs MUST be a text, because it contains all docIDs separated by ";"

Oy, that's a disastrous table design mistake. It breaks a basic rule of relational databases; atomicity, one value per cell. For this table to be queryable, `docIDs` needs to be projected to a child table in which each row has its matching `hashvalue` from this table ,and that individual docID. Then your query becomes trivially easy, and so does processing it.

PB