Postgres95 1.01 Distribution - Virgin SourcesPG95-1_01

1 files changed, 30 insertions, 0 deletions

diff --git a/src/test/suite/time.sql b/src/test/suite/time.sql
new file mode 100644
index 0000000000..aeaeaf1dd4
--- /dev/null
+++ b/src/test/suite/time.sql
@@ -0,0 +1,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;