| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: daisychain rows to detect value |
| Date: | 2017-03-27 15:59:37 |
| Message-ID: | CAKFQuwbprdJpGnNkGdYHf1yB6TX+ejZx9TOr7W87a3c1yhfE8w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Mon, Mar 27, 2017 at 2:58 AM, Gary Stainburn <
gary(dot)stainburn(at)ringways(dot)co(dot)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.
https://www.postgresql.org/docs/current/static/queries-with.html
Triggers are useful if you want to do the calculation during writes instead
of during reads.
https://www.postgresql.org/docs/current/static/trigger-definition.html
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gary Chambers | 2017-03-30 18:03:22 | Query Advice |
| Previous Message | Gary Stainburn | 2017-03-27 09:58:35 | daisychain rows to detect value |