Re: With Recursive / Recursive View question

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Perry Smith <pedz(at)easesoftware(dot)com>
Cc: pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: With Recursive / Recursive View question
Date: 2022-08-21 00:38:04
Message-ID: F8BFE453-C7AC-4F74-B159-7958F540D0AE@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Perry Smith 2022-08-21 02:02:41 Re: ***SPAM*** Re: With Recursive / Recursive View question
Previous Message Perry Smith 2022-08-20 22:42:27 With Recursive / Recursive View question