Jeffrey Becker wrote:
> 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?
Create Table SiteMap
(
NodeID blob not null PRIMARY KEY,
ParentID blob not null,
Title text NOT NULL UNIQUE,
Url text NOT NULL
);
Then index on (ParentID, NodeID) or something like that.
-Steve
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
