> On Aug 20, 2022, at 15:42, Perry Smith <pedz@xxxxxxxxxxxxxxxx> wrote: > > To rephrase, is it possible to write a view that would work from the child terms out towards the ancestors? Assuming that the concern is that you want to parameterize this predicate: WHERE basename = '10732.emlx' ... you might consider an SQL function taking basename as a parameter.
