I have a table 'SiteMap' defined as :
Create Table SiteMap
(
NodeID blob not null PRIMARY KEY,
Title text NOT NULL UNIQUE,
Url text NOT NULL
);
I'd like to index on the node's parent value as defined by the
expression ancestor(NodeID,1). 'ancestor' being a user defined
function.
However sqlite doesnt permit indicies on expressions, only columns.
Why is this? More importantly what's my best bet on achieveing
something similar?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
