misc.source

QUERY: UPDATE onek
   SET unique1 = onek.unique1 + 1;
QUERY: UPDATE onek
   SET unique1 = onek.unique1 - 1;
QUERY: UPDATE temp
   SET stringu1 = reverse_c16(onek.stringu1)
   WHERE onek.stringu1 = 'JBAAAA' and
	  onek.stringu1 = temp.stringu1;
NOTICE:Non-functional update, only first update is performed
NOTICE:Non-functional update, only first update is performed
QUERY: UPDATE temp
   SET stringu1 = reverse_c16(onek2.stringu1)
   WHERE onek2.stringu1 = 'JCAAAA' and
	  onek2.stringu1 = temp.stringu1;
NOTICE:Non-functional update, only first update is performed
NOTICE:Non-functional update, only first update is performed
QUERY: DROP TABLE temp;
QUERY: COPY onek TO '_OBJWD_/results/onek.data';
QUERY: DELETE FROM onek;
QUERY: COPY onek FROM '_OBJWD_/results/onek.data';
QUERY: SELECT unique1 FROM onek WHERE unique1 < 2;
unique1
-------
      0
      1
(2 rows)

QUERY: DELETE FROM onek2;
QUERY: COPY onek2 FROM '_OBJWD_/results/onek.data';
QUERY: SELECT unique1 FROM onek2 WHERE unique1 < 2;
unique1
-------
      0
      1
(2 rows)

QUERY: COPY BINARY stud_emp TO '_OBJWD_/results/stud_emp.data';
QUERY: DELETE FROM stud_emp;
QUERY: COPY BINARY stud_emp FROM '_OBJWD_/results/stud_emp.data';
QUERY: SELECT * FROM stud_emp;
name |age|location  |salary|manager|gpa|percent
-----+---+----------+------+-------+---+-------
jeff | 23|(8,7.7)   |   600|sharon |3.5|       
cim  | 30|(10.5,4.7)|   400|       |3.4|       
linda| 19|(0.9,6.1) |   100|       |2.9|       
(3 rows)

QUERY: SELECT * FROM a_star*;
class| a
-----+--
a    | 1
a    | 2
a    |  
b    | 3
b    | 4
b    |  
b    |  
c    | 5
c    | 6
c    |  
c    |  
e    |15
e    |16
e    |17
e    |  
e    |18
e    |  
e    |  
d    | 7
d    | 8
d    | 9
d    |10
d    |  
d    |11
d    |12
d    |13
d    |  
d    |  
d    |  
d    |14
d    |  
d    |  
d    |  
d    |  
f    |19
f    |20
f    |21
f    |22
f    |  
f    |24
f    |25
f    |26
f    |  
f    |  
f    |  
f    |27
f    |  
f    |  
f    |  
f    |  
(50 rows)

QUERY: SELECT *
   FROM b_star* x
   WHERE x.b = 'bumble'::text or x.a < 3;
class|a|b     
-----+-+------
b    | |bumble
(1 row)

QUERY: SELECT class, a
   FROM c_star* x
   WHERE x.c ~ 'hi'::text;
class| a
-----+--
c    | 5
c    |  
d    | 7
d    | 8
d    |10
d    |  
d    |12
d    |  
d    |  
d    |  
e    |15
e    |16
e    |  
e    |  
f    |19
f    |20
f    |21
f    |  
f    |24
f    |  
f    |  
f    |  
(22 rows)

QUERY: SELECT class, b, c
   FROM d_star* x
   WHERE x.a < 100;
class|b      |c         
-----+-------+----------
d    |grumble|hi sunita 
d    |stumble|hi koko   
d    |rumble |          
d    |       |hi kristin
d    |fumble |          
d    |       |hi avi    
d    |       |          
d    |       |          
(8 rows)

QUERY: SELECT class, c FROM e_star* x WHERE x.c NOTNULL;
class|c          
-----+-----------
e    |hi carol   
e    |hi bob     
e    |hi michelle
e    |hi elisa   
f    |hi claire  
f    |hi mike    
f    |hi marcel  
f    |hi keith   
f    |hi marc    
f    |hi allison 
f    |hi jeff    
f    |hi carl    
(12 rows)

QUERY: SELECT * FROM f_star* x WHERE x.c ISNULL;
class| a|c|  e|f                                        
-----+--+-+---+-----------------------------------------
f    |22| | -7|((111,555),(222,666),(333,777),(444,888))
f    |25| | -9|                                         
f    |26| |   |((11111,33333),(22222,44444))            
f    |  | |-11|((1111111,3333333),(2222222,4444444))    
f    |27| |   |                                         
f    |  | |-12|                                         
f    |  | |   |((11111111,33333333),(22222222,44444444))
f    |  | |   |                                         
(8 rows)

QUERY: ALTER TABLE f_star RENAME COLUMN f TO ff;
QUERY: ALTER TABLE e_star* RENAME COLUMN e TO ee;
QUERY: ALTER TABLE d_star* RENAME COLUMN d TO dd;
QUERY: ALTER TABLE c_star* RENAME COLUMN c TO cc;
QUERY: ALTER TABLE b_star* RENAME COLUMN b TO bb;
QUERY: ALTER TABLE a_star* RENAME COLUMN a TO aa;
QUERY: SELECT class, aa
   FROM a_star* x
   WHERE aa ISNULL;
class|aa
-----+--
a    |  
b    |  
b    |  
c    |  
c    |  
e    |  
e    |  
e    |  
d    |  
d    |  
d    |  
d    |  
d    |  
d    |  
d    |  
d    |  
f    |  
f    |  
f    |  
f    |  
f    |  
f    |  
f    |  
f    |  
(24 rows)

QUERY: ALTER TABLE a_star RENAME COLUMN aa TO foo;
QUERY: SELECT class, foo
   FROM a_star x
   WHERE x.foo >= 2;
class|foo
-----+---
a    |  2
(1 row)

QUERY: ALTER TABLE a_star RENAME COLUMN foo TO aa;
QUERY: SELECT *
   from a_star*
   WHERE aa < 1000;
class|aa
-----+--
a    | 1
a    | 2
b    | 3
b    | 4
c    | 5
c    | 6
e    |15
e    |16
e    |17
e    |18
d    | 7
d    | 8
d    | 9
d    |10
d    |11
d    |12
d    |13
d    |14
f    |19
f    |20
f    |21
f    |22
f    |24
f    |25
f    |26
f    |27
(26 rows)

QUERY: ALTER TABLE f_star ADD COLUMN f int4;
QUERY: UPDATE f_star SET f = 10;
QUERY: ALTER TABLE e_star* ADD COLUMN e int4;
QUERY: SELECT * FROM e_star*;
class|aa|cc         | ee|e
-----+--+-----------+---+-
e    |15|hi carol   | -1| 
e    |16|hi bob     |   | 
e    |17|           | -2| 
e    |  |hi michelle| -3| 
e    |18|           |   | 
e    |  |hi elisa   |   | 
e    |  |           | -4| 
f    |19|hi claire  | -5| 
f    |20|hi mike    | -6| 
f    |21|hi marcel  |   | 
f    |22|           | -7| 
f    |  |hi keith   | -8| 
f    |24|hi marc    |   | 
f    |25|           | -9| 
f    |26|           |   | 
f    |  |hi allison |-10| 
f    |  |hi jeff    |   | 
f    |  |           |-11| 
f    |27|           |   | 
f    |  |hi carl    |   | 
f    |  |           |-12| 
f    |  |           |   | 
f    |  |           |   | 
(23 rows)

QUERY: ALTER TABLE a_star* ADD COLUMN a text;
QUERY: SELECT class, aa, a FROM a_star*;
class|aa|a
-----+--+-
a    | 1| 
a    | 2| 
a    |  | 
b    | 3| 
b    | 4| 
b    |  | 
b    |  | 
c    | 5| 
c    | 6| 
c    |  | 
c    |  | 
e    |15| 
e    |16| 
e    |17| 
e    |  | 
e    |18| 
e    |  | 
e    |  | 
d    | 7| 
d    | 8| 
d    | 9| 
d    |10| 
d    |  | 
d    |11| 
d    |12| 
d    |13| 
d    |  | 
d    |  | 
d    |  | 
d    |14| 
d    |  | 
d    |  | 
d    |  | 
d    |  | 
f    |19| 
f    |20| 
f    |21| 
f    |22| 
f    |  | 
f    |24| 
f    |25| 
f    |26| 
f    |  | 
f    |  | 
f    |  | 
f    |27| 
f    |  | 
f    |  | 
f    |  | 
f    |  | 
(50 rows)

QUERY: SELECT p.name, p.hobbies.name FROM person p;
name |name       
-----+-----------
mike |posthacking
joe  |basketball 
sally|basketball 
(3 rows)

QUERY: SELECT p.name, p.hobbies.name FROM person* p;
name |name       
-----+-----------
mike |posthacking
joe  |basketball 
sally|basketball 
jeff |posthacking
(4 rows)

QUERY: SELECT DISTINCT hobbies_r.name, hobbies_r.equipment.name FROM hobbies_r;
name       |name         
-----------+-------------
basketball |hightops     
posthacking|advil        
posthacking|peet's coffee
skywalking |guts         
(4 rows)

QUERY: SELECT hobbies_r.name, hobbies_r.equipment.name FROM hobbies_r;
name       |name         
-----------+-------------
posthacking|advil        
posthacking|peet's coffee
posthacking|advil        
posthacking|peet's coffee
basketball |hightops     
basketball |hightops     
skywalking |guts         
(7 rows)

QUERY: SELECT p.name, p.hobbies.name, p.hobbies.equipment.name FROM person p;
name |name       |name         
-----+-----------+-------------
mike |posthacking|advil        
joe  |basketball |peet's coffee
sally|basketball |hightops     
(3 rows)

QUERY: SELECT p.name, p.hobbies.name, p.hobbies.equipment.name FROM person* p;
name |name       |name         
-----+-----------+-------------
mike |posthacking|advil        
joe  |basketball |peet's coffee
sally|basketball |hightops     
jeff |posthacking|advil        
(4 rows)

QUERY: SELECT p.hobbies.equipment.name, p.name, p.hobbies.name FROM person p;
name    |name |name       
--------+-----+-----------
advil   |mike |posthacking
hightops|joe  |basketball 
hightops|sally|basketball 
(3 rows)

QUERY: SELECT p.hobbies.equipment.name, p.name, p.hobbies.name FROM person* p;
name    |name |name       
--------+-----+-----------
advil   |mike |posthacking
hightops|joe  |basketball 
hightops|sally|basketball 
advil   |jeff |posthacking
(4 rows)

QUERY: SELECT p.hobbies.equipment.name, p.hobbies.name, p.name FROM person p;
name         |name       |name 
-------------+-----------+-----
advil        |posthacking|mike 
peet's coffee|basketball |joe  
hightops     |basketball |sally
(3 rows)

QUERY: SELECT p.hobbies.equipment.name, p.hobbies.name, p.name FROM person* p;
name         |name       |name 
-------------+-----------+-----
advil        |posthacking|mike 
peet's coffee|basketball |joe  
hightops     |basketball |sally
advil        |posthacking|jeff 
(4 rows)

QUERY: SELECT user_relns() AS user_relns
   ORDER BY user_relns;
user_relns     
---------------
a_star         
abstime_tbl    
aggtest        
arrtest        
b_star         
box_tbl        
bprime         
bt_c16_heap    
bt_f8_heap     
bt_i4_heap     
bt_txt_heap    
c_star         
char_tbl       
check2_tbl     
check_seq      
check_tbl      
circle_tbl     
city           
copy_tbl       
d_star         
datetime_tbl   
default_seq    
default_tbl    
defaultexpr_tbl
dept           
e_star         
emp            
equipment_r    
f_star         
fast_emp4000   
float4_tbl     
float8_tbl     
hash_c16_heap  
hash_f8_heap   
hash_i4_heap   
hash_txt_heap  
hobbies_r      
iexit          
ihighway       
insert_seq     
insert_tbl     
int2_tbl       
int4_tbl       
iportaltest    
lseg_tbl       
onek           
onek2          
path_tbl       
person         
point_tbl      
polygon_tbl    
ramp           
real_city      
reltime_tbl    
road           
shighway       
slow_emp4000   
street         
stud_emp       
student        
tenk1          
tenk2          
text_tbl       
timespan_tbl   
tinterval_tbl  
toyemp         
varchar_tbl    
xacttest       
(68 rows)