summaryrefslogtreecommitdiff
path: root/src/test/suite/varchar.sql
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2000-11-24 17:14:07 +0000
committerPeter Eisentraut <peter_e@gmx.net>2000-11-24 17:14:07 +0000
commit4cbeefb1e8a862d5fd4f3587125338765951d74d (patch)
tree32ee691ddc066690135790825cdb93c11f201753 /src/test/suite/varchar.sql
parent80dab5bd69cd5bcd064a7da9f3d1b22eb770925a (diff)
downloadpostgresql-4cbeefb1e8a862d5fd4f3587125338765951d74d.tar.gz
Remove obsolete test suite
Diffstat (limited to 'src/test/suite/varchar.sql')
-rw-r--r--src/test/suite/varchar.sql64
1 files changed, 0 insertions, 64 deletions
diff --git a/src/test/suite/varchar.sql b/src/test/suite/varchar.sql
deleted file mode 100644
index 0e83172208..0000000000
--- a/src/test/suite/varchar.sql
+++ /dev/null
@@ -1,64 +0,0 @@
----------------------------------------------------------------------------
---
--- varchar.sql-
--- test CHAR() and VARCHAR() adts
---
---
--- Copyright (c) 1994-5, Regents of the University of California
---
--- $Id: varchar.sql,v 1.1.1.1 1996/07/09 06:22:30 scrappy Exp $
---
----------------------------------------------------------------------------
-
--- test char(): insert w/ boundary cases
-create table f (x char(5));
-insert into f values ('zoo');
-insert into f values ('a');
-insert into f values ('jet');
-insert into f values ('abc');
-insert into f values ('');
-insert into f values ('a c');
-insert into f values ('abxyzxyz');
-select * from f;
-select * from f where x = 'jet';
-select * from f where x <> 'jet';
-select * from f where x < 'jet';
-select * from f where x <= 'jet';
-select * from f where x > 'jet';
-select * from f where x >= 'jet';
-select * from f where x = 'ab';
-select * from f where x <> 'ab';
-select * from f where x < 'ab';
-select * from f where x <= 'ab';
-select * from f where x > 'ab';
-select * from f where x >= 'ab';
-select * from f order by x;
--- test varchar(): insert w/ boundary cases
-create table ff (x varchar(5));
-insert into ff values ('a');
-insert into ff values ('zoo');
-insert into ff values ('jet');
-insert into ff values ('abc');
-insert into ff values ('');
-insert into ff values ('a c');
-insert into ff values ('abxyzxyz');
-select * from ff;
-select * from ff where x = 'jet';
-select * from ff where x <> 'jet';
-select * from ff where x < 'jet';
-select * from ff where x <= 'jet';
-select * from ff where x > 'jet';
-select * from ff where x >= 'jet';
-select * from ff where x = 'ab';
-select * from ff where x <> 'ab';
-select * from ff where x < 'ab';
-select * from ff where x <= 'ab';
-select * from ff where x > 'ab';
-select * from ff where x >= 'ab';
-select * from ff order by x using >;
-
-create index f_ind on f using btree (x bpchar_ops);
-create index ff_ind on ff using btree (x varchar_ops);
-
-drop table f;
-drop table ff;