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
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

Reply via email to