test.out

关系型数据库 Postgresql 6.5.2

slotname            |  roomno|            slotlink|backlink            
--------------------+--------+--------------------+--------------------
WS.001.1a           |001     |                    |PS.base.a1          
WS.001.1b           |001     |                    |PS.base.a2          
WS.001.2a           |001     |                    |PS.base.a3          
WS.001.2b           |001     |                    |                    
WS.001.3a           |001     |                    |                    
WS.001.3b           |001     |                    |                    
(6 rows)

QUERY: select * from PSlot where slotname ~ 'PS.base.a' order by slotname;
slotname            |pfname|            slotlink|backlink            
--------------------+------+--------------------+--------------------
PS.base.a1          |PF0_1 |                    |WS.001.1a           
PS.base.a2          |PF0_1 |                    |WS.001.1b           
PS.base.a3          |PF0_1 |                    |WS.001.2a           
PS.base.a4          |PF0_1 |                    |                    
PS.base.a5          |PF0_1 |                    |                    
PS.base.a6          |PF0_1 |                    |                    
(6 rows)

QUERY: update WSlot set backlink = 'PS.base.a4' where slotname = 'WS.001.2b';
QUERY: update WSlot set backlink = 'PS.base.a6' where slotname = 'WS.001.3a';
QUERY: select * from WSlot where roomno = '001' order by slotname;
slotname            |  roomno|            slotlink|backlink            
--------------------+--------+--------------------+--------------------
WS.001.1a           |001     |                    |PS.base.a1          
WS.001.1b           |001     |                    |PS.base.a2          
WS.001.2a           |001     |                    |PS.base.a3          
WS.001.2b           |001     |                    |PS.base.a4          
WS.001.3a           |001     |                    |PS.base.a6          
WS.001.3b           |001     |                    |                    
(6 rows)

QUERY: select * from PSlot where slotname ~ 'PS.base.a' order by slotname;
slotname            |pfname|            slotlink|backlink            
--------------------+------+--------------------+--------------------
PS.base.a1          |PF0_1 |                    |WS.001.1a           
PS.base.a2          |PF0_1 |                    |WS.001.1b           
PS.base.a3          |PF0_1 |                    |WS.001.2a           
PS.base.a4          |PF0_1 |                    |WS.001.2b           
PS.base.a5          |PF0_1 |                    |                    
PS.base.a6          |PF0_1 |                    |WS.001.3a           
(6 rows)

QUERY: update WSlot set backlink = 'PS.base.a6' where slotname = 'WS.001.3b';
QUERY: select * from WSlot where roomno = '001' order by slotname;
slotname            |  roomno|            slotlink|backlink            
--------------------+--------+--------------------+--------------------
WS.001.1a           |001     |                    |PS.base.a1          
WS.001.1b           |001     |                    |PS.base.a2          
WS.001.2a           |001     |                    |PS.base.a3          
WS.001.2b           |001     |                    |PS.base.a4          
WS.001.3a           |001     |                    |                    
WS.001.3b           |001     |                    |PS.base.a6          
(6 rows)

QUERY: select * from PSlot where slotname ~ 'PS.base.a' order by slotname;
slotname            |pfname|            slotlink|backlink            
--------------------+------+--------------------+--------------------
PS.base.a1          |PF0_1 |                    |WS.001.1a           
PS.base.a2          |PF0_1 |                    |WS.001.1b           
PS.base.a3          |PF0_1 |                    |WS.001.2a           
PS.base.a4          |PF0_1 |                    |WS.001.2b           
PS.base.a5          |PF0_1 |                    |                    
PS.base.a6          |PF0_1 |                    |WS.001.3b           
(6 rows)

QUERY: update WSlot set backlink = 'PS.base.a5' where slotname = 'WS.001.3a';
QUERY: select * from WSlot where roomno = '001' order by slotname;
slotname            |  roomno|            slotlink|backlink            
--------------------+--------+--------------------+--------------------
WS.001.1a           |001     |                    |PS.base.a1          
WS.001.1b           |001     |                    |PS.base.a2          
WS.001.2a           |001     |                    |PS.base.a3          
WS.001.2b           |001     |                    |PS.base.a4          
WS.001.3a           |001     |                    |PS.base.a5          
WS.001.3b           |001     |                    |PS.base.a6          
(6 rows)

QUERY: select * from PSlot where slotname ~ 'PS.base.a' order by slotname;
slotname            |pfname|            slotlink|backlink            
--------------------+------+--------------------+--------------------
PS.base.a1          |PF0_1 |                    |WS.001.1a           
PS.base.a2          |PF0_1 |                    |WS.001.1b           
PS.base.a3          |PF0_1 |                    |WS.001.2a           
PS.base.a4          |PF0_1 |                    |WS.001.2b           
PS.base.a5          |PF0_1 |                    |WS.001.3a           
PS.base.a6          |PF0_1 |                    |WS.001.3b           
(6 rows)

QUERY: insert into PField values ('PF1_2', 'Phonelines 1st floor');
QUERY: insert into PSlot values ('PS.1st.ta1', 'PF1_2', '', '');
QUERY: insert into PSlot values ('PS.1st.ta2', 'PF1_2', '', '');
QUERY: insert into PSlot values ('PS.1st.ta3', 'PF1_2', '', '');
QUERY: insert into PSlot values ('PS.1st.ta4', 'PF1_2', '', '');
QUERY: insert into PSlot values ('PS.1st.ta5', 'PF1_2', '', '');
QUERY: insert into PSlot values ('PS.1st.ta6', 'PF1_2', '', '');
QUERY: insert into PSlot values ('PS.1st.tb1', 'PF1_2', '', '');
QUERY: insert into PSlot values ('PS.1st.tb2', 'PF1_2', '', '');
QUERY: insert into PSlot values ('PS.1st.tb3', 'PF1_2', '', '');
QUERY: insert into PSlot values ('PS.1st.tb4', 'PF1_2', '', '');
QUERY: insert into PSlot values ('PS.1st.tb5', 'PF1_2', '', '');
QUERY: insert into PSlot values ('PS.1st.tb6', 'PF1_2', '', '');
QUERY: update PField set name = 'PF0_2' where name = 'PF0_X';
QUERY: select * from PSlot order by slotname;
slotname            |pfname|            slotlink|backlink            
--------------------+------+--------------------+--------------------
PS.1st.a1           |PF1_1 |                    |WS.101.1a           
PS.1st.a2           |PF1_1 |                    |WS.101.1b           
PS.1st.a3           |PF1_1 |                    |WS.101.2a           
PS.1st.a4           |PF1_1 |                    |WS.101.2b           
PS.1st.a5           |PF1_1 |                    |WS.101.3a           
PS.1st.a6           |PF1_1 |                    |WS.101.3b           
PS.1st.b1           |PF1_1 |                    |WS.102.1a           
PS.1st.b2           |PF1_1 |                    |WS.102.1b           
PS.1st.b3           |PF1_1 |                    |WS.102.2a           
PS.1st.b4           |PF1_1 |                    |WS.102.2b           
PS.1st.b5           |PF1_1 |                    |WS.102.3a           
PS.1st.b6           |PF1_1 |                    |WS.102.3b           
PS.1st.c1           |PF1_1 |                    |WS.105.1a           
PS.1st.c2           |PF1_1 |                    |WS.105.1b           
PS.1st.c3           |PF1_1 |                    |WS.105.2a           
PS.1st.c4           |PF1_1 |                    |WS.105.2b           
PS.1st.c5           |PF1_1 |                    |WS.105.3a           
PS.1st.c6           |PF1_1 |                    |WS.105.3b           
PS.1st.d1           |PF1_1 |                    |WS.106.1a           
PS.1st.d2           |PF1_1 |                    |WS.106.1b           
PS.1st.d3           |PF1_1 |                    |WS.106.2a           
PS.1st.d4           |PF1_1 |                    |WS.106.2b           
PS.1st.d5           |PF1_1 |                    |WS.106.3a           
PS.1st.d6           |PF1_1 |                    |WS.106.3b           
PS.1st.ta1          |PF1_2 |                    |                    
PS.1st.ta2          |PF1_2 |                    |                    
PS.1st.ta3          |PF1_2 |                    |                    
PS.1st.ta4          |PF1_2 |                    |                    
PS.1st.ta5          |PF1_2 |                    |                    
PS.1st.ta6          |PF1_2 |                    |                    
PS.1st.tb1          |PF1_2 |                    |                    
PS.1st.tb2          |PF1_2 |                    |                    
PS.1st.tb3          |PF1_2 |                    |                    
PS.1st.tb4          |PF1_2 |                    |                    
PS.1st.tb5          |PF1_2 |                    |                    
PS.1st.tb6          |PF1_2 |                    |                    
PS.base.a1          |PF0_1 |                    |WS.001.1a           
PS.base.a2          |PF0_1 |                    |WS.001.1b           
PS.base.a3          |PF0_1 |                    |WS.001.2a           
PS.base.a4          |PF0_1 |                    |WS.001.2b           
PS.base.a5          |PF0_1 |                    |WS.001.3a           
PS.base.a6          |PF0_1 |                    |WS.001.3b           
PS.base.b1          |PF0_1 |                    |WS.002.1a           
PS.base.b2          |PF0_1 |                    |WS.002.1b           
PS.base.b3          |PF0_1 |                    |WS.002.2a           
PS.base.b4          |PF0_1 |                    |WS.002.2b           
PS.base.b5          |PF0_1 |                    |WS.002.3a           
PS.base.b6          |PF0_1 |                    |WS.002.3b           
PS.base.c1          |PF0_1 |                    |WS.003.1a           
PS.base.c2          |PF0_1 |                    |WS.003.1b