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