So I've used CTE to solve a simple problem... I'm tempted to use it to fix more problems... but I'm wondering how to select different values at different levels. I know there's like 'select * from table where column in ( set,of,things) ' but can I index into the set? is there some sort of way I can specify an array of values?
would like to do something like ' select value from option_map where name is ["system","device","com port", "1" ] ' where the program statement would look more like GetOptionValue ( "/system/device/com port/1" ) where the name is really sort of registry like and variable in length... I could probably do some sort of indexing passing that exact string through and parsing in SQL the substrings of interest based on the level of the query... but would rather preparse the string.
