float.sql.out

来自「关系型数据库 Postgresql 6.5.2」· OUT 代码 · 共 331 行

QUERY: create table fl (x float4);
QUERY: insert into fl values ( 3.14 );
QUERY: insert into fl values ( 147.0 );
QUERY: insert into fl values ( 3.14 );
QUERY: insert into fl values ( -3.14 );
QUERY: select * from fl;
x      
------ 
3.14   
147    
3.14   
-3.14  
QUERY: select * from fl where x = 3.14;
x     
----- 
3.14  
3.14  
QUERY: select * from fl where x <> 3.14;
x      
------ 
147    
-3.14  
QUERY: select * from fl where x < 3.14;
x      
------ 
-3.14  
QUERY: select * from fl where x <= 3.14;
x      
------ 
3.14   
3.14   
-3.14  
QUERY: select * from fl where x > 3.14;
x    
---- 
147  
QUERY: select * from fl where x >= 3.14;
x     
----- 
3.14  
147   
3.14  
QUERY: select * from fl where x = '3.14';
x     
----- 
3.14  
3.14  
QUERY: select * from fl where x <> '3.14';
x      
------ 
147    
-3.14  
QUERY: select * from fl where x < '3.14';
x      
------ 
-3.14  
QUERY: select * from fl where x <= '3.14';
x      
------ 
3.14   
3.14   
-3.14  
QUERY: select * from fl where x > '3.14';
x    
---- 
147  
QUERY: select * from fl where x >= '3.14';
x     
----- 
3.14  
147   
3.14  
QUERY: select * from fl where x = '3.14'::float4;
x     
----- 
3.14  
3.14  
QUERY: select * from fl where x <> '3.14'::float4;
x      
------ 
147    
-3.14  
QUERY: select * from fl where x < '3.14'::float4;
x      
------ 
-3.14  
QUERY: select * from fl where x <= '3.14'::float4;
x      
------ 
3.14   
3.14   
-3.14  
QUERY: select * from fl where x > '3.14'::float4;
x    
---- 
147  
QUERY: select * from fl where x >= '3.14'::float4;
x     
----- 
3.14  
147   
3.14  
QUERY: select * from fl where x = '3.14'::float8;
x     
----- 
3.14  
3.14  
QUERY: select * from fl where x <> '3.14'::float8;
x      
------ 
147    
-3.14  
QUERY: select * from fl where x < '3.14'::float8;
x      
------ 
-3.14  
QUERY: select * from fl where x <= '3.14'::float8;
x      
------ 
3.14   
3.14   
-3.14  
QUERY: select * from fl where x > '3.14'::float8;
x    
---- 
147  
QUERY: select * from fl where x >= '3.14'::float8;
x     
----- 
3.14  
147   
3.14  
QUERY: update fl set x = x + 2.2;
QUERY: select * from fl;
x      
------ 
5.34   
149.2  
5.34   
-0.94  
QUERY: update fl set x = x - 2.2;
QUERY: select * from fl;
x      
------ 
3.14   
147    
3.14   
-3.14  
QUERY: update fl set x = x * 2.2;
QUERY: select * from fl;
x       
------- 
6.908   
323.4   
6.908   
-6.908  
QUERY: update fl set x = x / 2.2;
QUERY: select * from fl;
x      
------ 
3.14   
147    
3.14   
-3.14  
QUERY: create table fl8 (y float8);
QUERY: insert into fl8 values ( '3.14'::float8 );
QUERY: insert into fl8 values ( '147.0'::float8 );
QUERY: insert into fl8 values ( '3.140000001'::float8 );
QUERY: insert into fl8 values ( '-3.14'::float8);
QUERY: select * from fl8;
y            
------------ 
3.14         
147          
3.140000001  
-3.14        
QUERY: select * from fl8 where y = 3.14;
y            
------------ 
3.14         
3.140000001  
QUERY: select * from fl8 where y <> 3.14;
y      
------ 
147    
-3.14  
QUERY: select * from fl8 where y < 3.14;
y      
------ 
-3.14  
QUERY: select * from fl8 where y <= 3.14;
y            
------------ 
3.14         
3.140000001  
-3.14        
QUERY: select * from fl8 where y > 3.14;
y    
---- 
147  
QUERY: select * from fl8 where y >= 3.14;
y            
------------ 
3.14         
147          
3.140000001  
QUERY: select * from fl8 where y = '3.14';
y     
----- 
3.14  
QUERY: select * from fl8 where y <> '3.14';
y            
------------ 
147          
3.140000001  
-3.14        
QUERY: select * from fl8 where y < '3.14';
y      
------ 
-3.14  
QUERY: select * from fl8 where y <= '3.14';
y      
------ 
3.14   
-3.14  
QUERY: select * from fl8 where y > '3.14';
y            
------------ 
147          
3.140000001  
QUERY: select * from fl8 where y >= '3.14';
y            
------------ 
3.14         
147          
3.140000001  
QUERY: select * from fl8 where y = '3.14'::float4;
y            
------------ 
3.14         
3.140000001  
QUERY: select * from fl8 where y <> '3.14'::float4;
y      
------ 
147    
-3.14  
QUERY: select * from fl8 where y < '3.14'::float4;
y      
------ 
-3.14  
QUERY: select * from fl8 where y <= '3.14'::float4;
y            
------------ 
3.14         
3.140000001  
-3.14        
QUERY: select * from fl8 where y > '3.14'::float4;
y    
---- 
147  
QUERY: select * from fl8 where y >= '3.14'::float4;
y            
------------ 
3.14         
147          
3.140000001  
QUERY: select * from fl8 where y = '3.14'::float8;
y     
----- 
3.14  
QUERY: select * from fl8 where y <> '3.14'::float8;
y            
------------ 
147          
3.140000001  
-3.14        
QUERY: select * from fl8 where y < '3.14'::float8;
y      
------ 
-3.14  
QUERY: select * from fl8 where y <= '3.14'::float8;
y      
------ 
3.14   
-3.14  
QUERY: select * from fl8 where y > '3.14'::float8;
y            
------------ 
147          
3.140000001  
QUERY: select * from fl8 where y >= '3.14'::float8;
y            
------------ 
3.14         
147          
3.140000001  
QUERY: update fl8 set y = y + '2.2'::float8;
QUERY: select * from fl8;
y            
------------ 
5.34         
149.2        
5.340000001  
-0.94        
QUERY: update fl8 set y = y - '2.2'::float8;
QUERY: select * from fl8;
y            
------------ 
3.14         
147          
3.140000001  
-3.14        
QUERY: update fl8 set y = y * '2.2'::float8;
QUERY: select * from fl8;
y             
------------- 
6.908         
323.4         
6.9080000022  
-6.908        
QUERY: update fl8 set y = y / '2.2'::float8;
QUERY: select * from fl8;
y            
------------ 
3.14         
147          
3.140000001  
-3.14        
QUERY: drop table fl;
QUERY: drop table fl8;