> On Aug 20, 2022, at 19:38, Christophe Pettus <xof@thebuild.com> wrote:
>
>
>
>> 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.
Yea. If I did a function, I would just pass in the id. I’ve used functions only rarely. For whatever reason, I’ve
alwaysbeen very skittish around them. But perhaps I need to grow up.
Thank you again,
Perry