Re: With Recursive / Recursive View question

[Christophe Pettus]

> On Aug 20, 2022, at 15:42, Perry Smith <p...@easesoftware.com> 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.