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

From Perry Smith
Subject Re: ***SPAM*** Re: With Recursive / Recursive View question
Date
Msg-id 3E66E12E-DE90-4931-8D71-0CA0B21CD68A@easesoftware.com
Whole thread Raw
In response to Re: With Recursive / Recursive View question  (Christophe Pettus <xof@thebuild.com>)
List pgsql-general

> 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


Attachment

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: With Recursive / Recursive View question
Next
From: Perry Smith
Date:
Subject: Re: ***SPAM*** Re: With Recursive / Recursive View question