I get errors like this when referencing arrays in an XQL file
Is there any way to work around this?
invalid command name "c.name]"
while executing
"c.name\] as path"
invoked from within
"subst -nobackslashes {
with recursive tree as (
select c.category_id, c.parent_category_id, c.name, 0 as level,array\[c.name\] as path
fr..."
with recursive tree as (
select c.category_id, c.parent_category_id, c.name, 0 as level,array\[c.name\] as path
from ctrl_categories c
where c.parent_category_id = ctrl_category__lookup('//Personnel Title')
union
select child.category_id, child.parent_category_id, child.name, tree.level + 1 as level, (tree.path || c.name)::varchar(300)\[\]
from ctrl_categories child, tree
where child.parent_category_id = tree.category_id)
select lpad(' ', (level-1)*4*6 + 1, ' ') || tree.name as name,
tree.category_id
from tree
order by path