varchar.sql.out

关系型数据库 Postgresql 6.5.2

QUERY: create table f (x char(5));
QUERY: insert into f values ('zoo');
QUERY: insert into f values ('a');
QUERY: insert into f values ('jet');
QUERY: insert into f values ('abc');
QUERY: insert into f values ('');
QUERY: insert into f values ('a c');
QUERY: insert into f values ('abxyzxyz');
QUERY: select * from f;
x      
------ 
zoo    
a      
jet    
abc    
       
a c    
abxyz  
QUERY: select * from f where x = 'jet';
x      
------ 
jet    
QUERY: select * from f where x <> 'jet';
x      
------ 
zoo    
a      
abc    
       
a c    
abxyz  
QUERY: select * from f where x < 'jet';
x      
------ 
a      
abc    
       
a c    
abxyz  
QUERY: select * from f where x <= 'jet';
x      
------ 
a      
jet    
abc    
       
a c    
abxyz  
QUERY: select * from f where x > 'jet';
x      
------ 
zoo    
QUERY: select * from f where x >= 'jet';
x      
------ 
zoo    
jet    
       
QUERY: select * from f where x = 'ab';
x  
-- 
QUERY: select * from f where x <> 'ab';
x      
------ 
zoo    
a      
jet    
abc    
       
a c    
abxyz  
QUERY: select * from f where x < 'ab';
x      
------ 
a      
       
a c    
QUERY: select * from f where x <= 'ab';
x      
------ 
a      
abc    
       
a c    
abxyz  
QUERY: select * from f where x > 'ab';
x      
------ 
zoo    
jet    
abc    
abxyz  
QUERY: select * from f where x >= 'ab';
x      
------ 
zoo    
a      
jet    
abc    
       
abxyz  
QUERY: select * from f order by x;
x      
------ 
       
a      
a c    
abc    
abxyz  
jet    
zoo    
QUERY: create table ff (x varchar(5));
QUERY: insert into ff values ('a');
QUERY: insert into ff values ('zoo');
QUERY: insert into ff values ('jet');
QUERY: insert into ff values ('abc');
QUERY: insert into ff values ('');
QUERY: insert into ff values ('a c');
QUERY: insert into ff values ('abxyzxyz');
QUERY: select * from ff;
x      
------ 
a      
zoo    
jet    
abc    
       
a c    
abxyz  
QUERY: select * from ff where x = 'jet';
x    
---- 
jet  
QUERY: select * from ff where x <> 'jet';
x      
------ 
a      
zoo    
abc    
       
a c    
abxyz  
QUERY: select * from ff where x < 'jet';
x      
------ 
a      
abc    
       
a c    
abxyz  
QUERY: select * from ff where x <= 'jet';
x      
------ 
a      
jet    
abc    
       
a c    
abxyz  
QUERY: select * from ff where x > 'jet';
x    
---- 
zoo  
QUERY: select * from ff where x >= 'jet';
x    
---- 
zoo  
jet  
     
QUERY: select * from ff where x = 'ab';
x  
-- 
QUERY: select * from ff where x <> 'ab';
x      
------ 
a      
zoo    
jet    
abc    
       
a c    
abxyz  
QUERY: select * from ff where x < 'ab';
x    
---- 
a    
     
a c  
QUERY: select * from ff where x <= 'ab';
x      
------ 
a      
abc    
       
a c    
abxyz  
QUERY: select * from ff where x > 'ab';
x      
------ 
zoo    
jet    
abc    
abxyz  
QUERY: select * from ff where x >= 'ab';
x      
------ 
a      
zoo    
jet    
abc    
       
abxyz  
QUERY: select * from ff order by x using >;
x      
------ 
zoo    
jet    
abxyz  
abc    
a c    
a      
       
QUERY: create index f_ind on f using btree (x bpchar_ops);
QUERY: create index ff_ind on ff using btree (x varchar_ops);
QUERY: drop table f;
QUERY: drop table ff;