agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Gary Stainburn <gary.stainburn@ringways.co.uk>
To: pgsql-sql@postgresql.org
Subject: daisychain rows to detect value
Date: Mon, 27 Mar 2017 10:58:35 +0100
Message-ID: <201703271058.35123.gary.stainburn@ringways.co.uk> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
I have a table of network ports. These ports are part of something, be it a
cabinet patch panel, or a network switch.
np_connects_to references a hardware ID, which can be the cabinet,
switch,router etc. containing the port.
no_port is the name of the port.
np_untagged_vlan is the VLAN ID for the port, with NULL being allowed.
Each port can then be patched to another port.
For example:
np_connects_to | np_port | np_patch_to | np_patch_port | np_untagged_vlan
---------------+---------+-------------+---------------+-----------------
1 | 01 | | | 1
2 | 23B | 1 | 01 |
3 | 23A | 2 | 23B |
Row 1 shows a switch port set to VLAN 1.
Row 2 shows a port in cabiner 'A' (Panel B port 23) which is patched to the
switch port.
Row 3 shows a port in cabinet 'B' (Panel A port 23) which is the other end
cabinet A port 23B
Is there a way to be able to propogate the untagged VLAN to any port patched
to it?
--
https://fundraise.cancerresearchuk.org/page/garys-march-march
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
view thread (2+ messages) latest in thread
Message-ID: <201703271058.35123.gary.stainburn@ringways.co.uk>
Permalink: ../201703271058.35123.gary.stainburn@ringways.co.uk/
Also on: postgresql.org/message-id/201703271058.35123.gary.stainburn@ringways.co.uk
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gary.stainburn@ringways.co.uk
Subject: Re: daisychain rows to detect value
In-Reply-To: <201703271058.35123.gary.stainburn@ringways.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox