rules.out

关系型数据库 Postgresql 6.5.2

QUERY: insert into rtest_system values ('orion', 'Linux Jan Wieck');
QUERY: insert into rtest_system values ('notjw', 'WinNT Jan Wieck (notebook)');
QUERY: insert into rtest_system values ('neptun', 'Fileserver');
QUERY: insert into rtest_interface values ('orion', 'eth0');
QUERY: insert into rtest_interface values ('orion', 'eth1');
QUERY: insert into rtest_interface values ('notjw', 'eth0');
QUERY: insert into rtest_interface values ('neptun', 'eth0');
QUERY: insert into rtest_person values ('jw', 'Jan Wieck');
QUERY: insert into rtest_person values ('bm', 'Bruce Momjian');
QUERY: insert into rtest_admin values ('jw', 'orion');
QUERY: insert into rtest_admin values ('jw', 'notjw');
QUERY: insert into rtest_admin values ('bm', 'neptun');
QUERY: update rtest_system set sysname = 'pluto' where sysname = 'neptun';
QUERY: select * from rtest_interface;
sysname|ifname
-------+------
orion  |eth0  
orion  |eth1  
notjw  |eth0  
pluto  |eth0  
(4 rows)

QUERY: select * from rtest_admin;
pname|sysname
-----+-------
jw   |orion  
jw   |notjw  
bm   |pluto  
(3 rows)

QUERY: update rtest_person set pname = 'jwieck' where pdesc = 'Jan Wieck';
QUERY: select * from rtest_admin order by pname, sysname;
pname |sysname
------+-------
bm    |pluto  
jwieck|notjw  
jwieck|orion  
(3 rows)

QUERY: delete from rtest_system where sysname = 'orion';
QUERY: select * from rtest_interface;
sysname|ifname
-------+------
notjw  |eth0  
pluto  |eth0  
(2 rows)

QUERY: select * from rtest_admin;
pname |sysname
------+-------
bm    |pluto  
jwieck|notjw  
(2 rows)

QUERY: insert into rtest_emp values ('wiech', '5000.00');
QUERY: insert into rtest_emp values ('gates', '80000.00');
QUERY: update rtest_emp set ename = 'wiecx' where ename = 'wiech';
QUERY: update rtest_emp set ename = 'wieck', salary = '6000.00' where ename = 'wiecx';
QUERY: update rtest_emp set salary = '7000.00' where ename = 'wieck';
QUERY: delete from rtest_emp where ename = 'gates';
QUERY: select ename, who = current_user as "matches user", action, newsal, oldsal from rtest_emplog order by ename, action, newsal;
ename               |matches user|action    |newsal    |oldsal    
--------------------+------------+----------+----------+----------
gates               |t           |fired     |$0.00     |$80,000.00
gates               |t           |hired     |$80,000.00|$0.00     
wiech               |t           |hired     |$5,000.00 |$0.00     
wieck               |t           |honored   |$6,000.00 |$5,000.00 
wieck               |t           |honored   |$7,000.00 |$6,000.00 
(5 rows)

QUERY: insert into rtest_empmass values ('meyer', '4000.00');
QUERY: insert into rtest_empmass values ('maier', '5000.00');
QUERY: insert into rtest_empmass values ('mayr', '6000.00');
QUERY: insert into rtest_emp select * from rtest_empmass;
QUERY: select ename, who = current_user as "matches user", action, newsal, oldsal from rtest_emplog order by ename, action, newsal;
ename               |matches user|action    |newsal    |oldsal    
--------------------+------------+----------+----------+----------
gates               |t           |fired     |$0.00     |$80,000.00
gates               |t           |hired     |$80,000.00|$0.00     
maier               |t           |hired     |$5,000.00 |$0.00     
mayr                |t           |hired     |$6,000.00 |$0.00     
meyer               |t           |hired     |$4,000.00 |$0.00     
wiech               |t           |hired     |$5,000.00 |$0.00     
wieck               |t           |honored   |$6,000.00 |$5,000.00 
wieck               |t           |honored   |$7,000.00 |$6,000.00 
(8 rows)

QUERY: update rtest_empmass set salary = salary + '1000.00';
QUERY: update rtest_emp set salary = rtest_empmass.salary where ename = rtest_empmass.ename;
QUERY: select ename, who = current_user as "matches user", action, newsal, oldsal from rtest_emplog order by ename, action, newsal;
ename               |matches user|action    |newsal    |oldsal    
--------------------+------------+----------+----------+----------
gates               |t           |fired     |$0.00     |$80,000.00
gates               |t           |hired     |$80,000.00|$0.00     
maier               |t           |hired     |$5,000.00 |$0.00     
maier               |t           |honored   |$6,000.00 |$5,000.00 
mayr                |t           |hired     |$6,000.00 |$0.00     
mayr                |t           |honored   |$7,000.00 |$6,000.00 
meyer               |t           |hired     |$4,000.00 |$0.00     
meyer               |t           |honored   |$5,000.00 |$4,000.00 
wiech               |t           |hired     |$5,000.00 |$0.00     
wieck               |t           |honored   |$6,000.00 |$5,000.00 
wieck               |t           |honored   |$7,000.00 |$6,000.00 
(11 rows)

QUERY: delete from rtest_emp where ename = rtest_empmass.ename;
QUERY: select ename, who = current_user as "matches user", action, newsal, oldsal from rtest_emplog order by ename, action, newsal;
ename               |matches user|action    |newsal    |oldsal    
--------------------+------------+----------+----------+----------
gates               |t           |fired     |$0.00     |$80,000.00
gates               |t           |hired     |$80,000.00|$0.00     
maier               |t           |fired     |$0.00     |$6,000.00 
maier               |t           |hired     |$5,000.00 |$0.00     
maier               |t           |honored   |$6,000.00 |$5,000.00 
mayr                |t           |fired     |$0.00     |$7,000.00 
mayr                |t           |hired     |$6,000.00 |$0.00     
mayr                |t           |honored   |$7,000.00 |$6,000.00 
meyer               |t           |fired     |$0.00     |$5,000.00 
meyer               |t           |hired     |$4,000.00 |$0.00     
meyer               |t           |honored   |$5,000.00 |$4,000.00 
wiech               |t           |hired     |$5,000.00 |$0.00     
wieck               |t           |honored   |$6,000.00 |$5,000.00 
wieck               |t           |honored   |$7,000.00 |$6,000.00 
(14 rows)

QUERY: insert into rtest_t4 values (1, 'Record should go to rtest_t4');
QUERY: insert into rtest_t4 values (2, 'Record should go to rtest_t4');
QUERY: insert into rtest_t4 values (10, 'Record should go to rtest_t5');
QUERY: insert into rtest_t4 values (15, 'Record should go to rtest_t5');
QUERY: insert into rtest_t4 values (19, 'Record should go to rtest_t5 and t7');
QUERY: insert into rtest_t4 values (20, 'Record should go to rtest_t4 and t6');
QUERY: insert into rtest_t4 values (26, 'Record should go to rtest_t4 and t8');
QUERY: insert into rtest_t4 values (28, 'Record should go to rtest_t4 and t8');
QUERY: insert into rtest_t4 values (30, 'Record should go to rtest_t4');
QUERY: insert into rtest_t4 values (40, 'Record should go to rtest_t4');
QUERY: select * from rtest_t4;
 a|b                                  
--+-----------------------------------
 1|Record should go to rtest_t4       
 2|Record should go to rtest_t4       
20|Record should go to rtest_t4 and t6
26|Record should go to rtest_t4 and t8
28|Record should go to rtest_t4 and t8
30|Record should go to rtest_t4       
40|Record should go to rtest_t4       
(7 rows)

QUERY: select * from rtest_t5;
 a|b                                  
--+-----------------------------------
10|Record should go to rtest_t5       
15|Record should go to rtest_t5       
19|Record should go to rtest_t5 and t7
(3 rows)

QUERY: select * from rtest_t6;
 a|b                                  
--+-----------------------------------
20|Record should go to rtest_t4 and t6
(1 row)

QUERY: select * from rtest_t7;
 a|b                                  
--+-----------------------------------
19|Record should go to rtest_t5 and t7
(1 row)

QUERY: select * from rtest_t8;
 a|b                                  
--+-----------------------------------
26|Record should go to rtest_t4 and t8
28|Record should go to rtest_t4 and t8
(2 rows)

QUERY: delete from rtest_t4;
QUERY: delete from rtest_t5;
QUERY: delete from rtest_t6;
QUERY: delete from rtest_t7;
QUERY: delete from rtest_t8;
QUERY: insert into rtest_t9 values (1, 'Record should go to rtest_t4');
QUERY: insert into rtest_t9 values (2, 'Record should go to rtest_t4');
QUERY: insert into rtest_t9 values (10, 'Record should go to rtest_t5');
QUERY: insert into rtest_t9 values (15, 'Record should go to rtest_t5');
QUERY: insert into rtest_t9 values (19, 'Record should go to rtest_t5 and t7');
QUERY: insert into rtest_t9 values (20, 'Record should go to rtest_t4 and t6');
QUERY: insert into rtest_t9 values (26, 'Record should go to rtest_t4 and t8');
QUERY: insert into rtest_t9 values (28, 'Record should go to rtest_t4 and t8');
QUERY: insert into rtest_t9 values (30, 'Record should go to rtest_t4');
QUERY: insert into rtest_t9 values (40, 'Record should go to rtest_t4');
QUERY: insert into rtest_t4 select * from rtest_t9 where a < 20;
QUERY: select * from rtest_t4;
a|b                           
-+----------------------------
1|Record should go to rtest_t4
2|Record should go to rtest_t4
(2 rows)

QUERY: select * from rtest_t5;
 a|b                                  
--+-----------------------------------
10|Record should go to rtest_t5       
15|Record should go to rtest_t5       
19|Record should go to rtest_t5 and t7
(3 rows)

QUERY: select * from rtest_t6;
a|b
-+-
(0 rows)

QUERY: select * from rtest_t7;
 a|b                                  
--+-----------------------------------
19|Record should go to rtest_t5 and t7
(1 row)

QUERY: select * from rtest_t8;
a|b
-+-
(0 rows)

QUERY: insert into rtest_t4 select * from rtest_t9 where b ~ 'and t8';
QUERY: select * from rtest_t4;
 a|b                                  
--+-----------------------------------
 1|Record should go to rtest_t4       
 2|Record should go to rtest_t4       
26|Record should go to rtest_t4 and t8
28|Record should go to rtest_t4 and t8
(4 rows)

QUERY: select * from rtest_t5;
 a|b                                  
--+-----------------------------------
10|Record should go to rtest_t5       
15|Record should go to rtest_t5       
19|Record should go to rtest_t5 and t7
(3 rows)

QUERY: select * from rtest_t6;
a|b
-+-
(0 rows)

QUERY: select * from rtest_t7;
 a|b                                  
--+-----------------------------------
19|Record should go to rtest_t5 and t7
(1 row)

QUERY: select * from rtest_t8;
 a|b                                  
--+-----------------------------------
26|Record should go to rtest_t4 and t8
28|Record should go to rtest_t4 and t8
(2 rows)

QUERY: insert into rtest_t4 select a + 1, b from rtest_t9 where a in (20, 30, 40);
QUERY: select * from rtest_t4;
 a|b                                  
--+-----------------------------------
 1|Record should go to rtest_t4       
 2|Record should go to rtest_t4       
26|Record should go to rtest_t4 and t8
28|Record should go to rtest_t4 and t8
21|Record should go to rtest_t4 and t6
31|Record should go to rtest_t4       
41|Record should go to rtest_t4       
(7 rows)

QUERY: select * from rtest_t5;
 a|b                                  
--+-----------------------------------
10|Record should go to rtest_t5       
15|Record should go to rtest_t5       
19|Record should go to rtest_t5 and t7
(3 rows)

QUERY: select * from rtest_t6;
 a|b                                  
--+-----------------------------------
21|Record should go to rtest_t4 and t6