efcore.pg
efcore.pg copied to clipboard
Support ltree array query?
var posTree = new LTree[]{"A.B","C.D"};
var nq = db.Positions.Where(x => posTree.Any(z=> x.Tree.IsDescendantOf(z)))
Can it translate to sql:
select * from positions p
where ltree2text(p.tree) <@ any(array ['A.B','C.D'])
When working on this, consider translating array.Any in a generic way (PG ANY apparently allows any operator).