From: Gary Stainburn <gary.stainburn@ringways.co.uk>
Organization: Ringways Garages Ltd
To: pgsql-sql@postgresql.org
Subject: daisychain rows to detect value
Date: Mon, 27 Mar 2017 10:58:35 +0100
User-Agent: KMail/1.9.10
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <201703271058.35123.gary.stainburn@ringways.co.uk>
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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