sqlcompat.sql.out

关系型数据库 Postgresql 6.5.2

QUERY: create table st1 (x int, y integer, z int4);
QUERY: insert into st1 values (1);
QUERY: insert into st1 values (10);
QUERY: select * from st1;
x   y  z  
--- -- -- 
1         
10        
QUERY: create table st2 (x smallint, y int2);
QUERY: insert into st2 values (1);
QUERY: insert into st2 values (10);
QUERY: select * from st2;
x   y  
--- -- 
1      
10     
QUERY: create table st3 (x float, y real, z float4);
QUERY: insert into st3 values (1);
QUERY: insert into st3 values (10);
QUERY: select * from st3;
x   y  z  
--- -- -- 
1         
10        
QUERY: create table st4 (x float8);
QUERY: insert into st4 values (1);
QUERY: insert into st4 values (10);
QUERY: select * from st4;
x   
--- 
1   
10  
QUERY: select max(x) from st1;
max  
---- 
10   
QUERY: select min(x) from st1;
min  
---- 
1    
QUERY: select sum(x) from st1;
sum  
---- 
11   
QUERY: select avg(x) from st1;
avg  
---- 
5    
QUERY: select max(x) from st2;
max  
---- 
10   
QUERY: select min(x) from st2;
min  
---- 
1    
QUERY: select sum(x) from st2;
sum  
---- 
11   
QUERY: select avg(x) from st2;
avg  
---- 
5    
QUERY: select max(x) from st3;
max  
---- 
10   
QUERY: select min(x) from st3;
min  
---- 
1    
QUERY: select sum(x) from st3;
sum  
---- 
11   
QUERY: select avg(x) from st3;
avg  
---- 
5.5  
QUERY: select max(x) from st4;
max  
---- 
10   
QUERY: select min(x) from st4;
min  
---- 
1    
QUERY: select sum(x) from st4;
sum  
---- 
11   
QUERY: select avg(x) from st4;
avg  
---- 
5.5  
QUERY: drop table st1;
QUERY: drop table st2;
QUERY: drop table st3;
QUERY: drop table st4;