time.sql.out

关系型数据库 Postgresql 6.5.2

QUERY: create table tt (t time);
QUERY: insert into tt values ('6:22:19.95');
QUERY: insert into tt values ('5:31:19.94');
QUERY: insert into tt values ('2:29:1.996');
QUERY: insert into tt values ('23:59:59.93');
QUERY: insert into tt values ('0:0:0.0');
QUERY: insert into tt values ('2:29:1.996');
QUERY: select * from tt;
t                
---------------- 
06:22:19.950001  
05:31:19.940001  
02:29:01.996000  
23:59:59.930000  
00:00:00.000000  
02:29:01.996000  
QUERY: select * from tt order by t;
t                
---------------- 
00:00:00.000000  
02:29:01.996000  
02:29:01.996000  
05:31:19.940001  
06:22:19.950001  
23:59:59.930000  
QUERY: select * from tt order by t using >;
t                
---------------- 
23:59:59.930000  
06:22:19.950001  
05:31:19.940001  
02:29:01.996000  
02:29:01.996000  
00:00:00.000000  
QUERY: select * from tt where t = '2:29:1.996';
t                
---------------- 
02:29:01.996000  
02:29:01.996000  
QUERY: select * from tt where t <> '2:29:1.996';
t                
---------------- 
06:22:19.950001  
05:31:19.940001  
23:59:59.930000  
00:00:00.000000  
QUERY: select * from tt where t < '2:29:1.996';
t                
---------------- 
00:00:00.000000  
QUERY: select * from tt where t <= '2:29:1.996';
t                
---------------- 
02:29:01.996000  
00:00:00.000000  
02:29:01.996000  
QUERY: select * from tt where t > '2:29:1.996';
t                
---------------- 
06:22:19.950001  
05:31:19.940001  
23:59:59.930000  
QUERY: select * from tt where t >= '2:29:1.996';
t                
---------------- 
06:22:19.950001  
05:31:19.940001  
02:29:01.996000  
23:59:59.930000  
02:29:01.996000  
QUERY: create index tt_ind on tt using btree (t time_ops);
QUERY: drop table tt;