Re: With Recursive / Recursive View question - Mailing list pgsql-general

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