blob: aeaeaf1dd4177236976407f975389a3d04d74c2d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
---------------------------------------------------------------------------
--
-- time.sql-
-- test TIME adt
--
--
-- Copyright (c) 1994-5, Regents of the University of California
--
-- $Id: time.sql,v 1.1.1.1 1996/07/09 06:22:30 scrappy Exp $
--
---------------------------------------------------------------------------
create table tt (t time);
insert into tt values ('6:22:19.95');
insert into tt values ('5:31:19.94');
insert into tt values ('2:29:1.996');
insert into tt values ('23:59:59.93');
insert into tt values ('0:0:0.0');
insert into tt values ('2:29:1.996');
select * from tt;
select * from tt order by t;
select * from tt order by t using >;
select * from tt where t = '2:29:1.996';
select * from tt where t <> '2:29:1.996';
select * from tt where t < '2:29:1.996';
select * from tt where t <= '2:29:1.996';
select * from tt where t > '2:29:1.996';
select * from tt where t >= '2:29:1.996';
create index tt_ind on tt using btree (t time_ops);
drop table tt;
|
