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