Home > mailing lists

Re: daisychain rows to detect value - Mailing list pgsql-sql

From	David G. Johnston
Subject	Re: daisychain rows to detect value
Date	March 27, 2017 21:59:37
Msg-id	CAKFQuwbprdJpGnNkGdYHf1yB6TX+ejZx9TOr7W87a3c1yhfE8w@mail.gmail.com Whole thread Raw
In response to	daisychain rows to detect value (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List	pgsql-sql

On Mon, Mar 27, 2017 at 2:58 AM, Gary Stainburn <gary.stainburn@ringways.co.uk> wrote:

Is there a way to be able to propogate the untagged VLAN to any port patched
to it?

PostgreSQL natively provides a Recursive CTE capability that can be used to solve arbitrary depth hierarchy problems.

Triggers are useful if you want to do the calculation during writes instead of during reads.

David J.

From: Gary Stainburn
Date: 27 March 2017, 15:58:35
Subject: daisychain rows to detect value

From: Gary Chambers
Date: 31 March 2017, 00:03:22
Subject: Query Advice