On 20 Oct 2010, at 4:10pm, Mathieu Schroeter wrote:

> /* for one data in a table */
> struct data {
>   void *value;
>   ...
>   const struct idx *idx;  /* ptr on the entry in 'idx_foobar' */
> } *my_data_in_the_table

You're still thinking too computery.  Think of an index the way you'd think of 
a book with an index.  The book has its text, in the front of the book.  Then 
it may have an index by keyword, then it might have an index by surname.

The text itself has no pointer to indexes at all.  If you come across the word 
'college' you don't even know whether the publisher thought that that word was 
worth indexing.  You could tear all the index pages (or perhaps even just the 
pages of one of the indexes) out of the back of the book and the text of the 
book would still be perfectly valid and sensible.

Now go back to the question you were originally asking.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to