1 files changed, 0 insertions, 87 deletions
diff --git a/doc/dominfo.txt b/doc/dominfo.txt
deleted file mode 100644
index a439ff6c3c..0000000000
--- a/doc/dominfo.txt
+++ /dev/null
@@ -1,87 +0,0 @@
-
-
--- Test Comment / Drop
-create domain domaindroptest int4;
-comment on domain domaindroptest is 'About to drop this..';
-
-select * from pg_type where typname = 'domaindroptest';
-
-drop domain domaindroptest restrict;
-
-select * from pg_type where typname = 'domaindroptest';
-
--- TEST Domains.
-
-create domain domainvarchar varchar(5);
-create domain domainnumeric numeric(8,2);
-create domain domainint4 int4;
-create domain domaintext text;
-
-
--- Test tables using domains
-create table basictest
-           ( testint4 domainint4
-           , testtext domaintext
-           , testvarchar domainvarchar
-           , testnumeric domainnumeric
-           );
-
-INSERT INTO basictest values ('88', 'haha', 'short', '123.12');      -- Good
-INSERT INTO basictest values ('88', 'haha', 'short text', '123.12'); -- Bad varchar
-INSERT INTO basictest values ('88', 'haha', 'short', '123.1212');    -- Truncate numeric
-select * from basictest;
-
-
--- Array Test
-create domain domainint4arr int4[1];
-create domain domaintextarr text[2][3];
-
-create table arrtest
-           ( testint4arr domainint4arr
-           , testtextarr domaintextarr
-           );
-INSERT INTO arrtest values ('{2,2}', '{{"a","b"}{"c","d"}}');
-INSERT INTO arrtest values ('{{2,2}{2,2}}', '{{"a","b"}}');
-INSERT INTO arrtest values ('{2,2}', '{{"a","b"}{"c","d"}{"e"}}');
-INSERT INTO arrtest values ('{2,2}', '{{"a"}{"c"}}');
-INSERT INTO arrtest values (NULL, '{{"a","b"}{"c","d","e"}}');
-
-
-create domain dnotnull varchar(15) NOT NULL;
-create domain dnull    varchar(15) NULL;
-
-create table nulltest
-           ( col1 dnotnull
-           , col2 dnotnull NULL  -- NOT NULL in the domain cannot be overridden
-           , col3 dnull    NOT NULL
-           , col4 dnull
-           );
-INSERT INTO nulltest DEFAULT VALUES;
-INSERT INTO nulltest values ('a', 'b', 'c', 'd');  -- Good
-INSERT INTO nulltest values (NULL, 'b', 'c', 'd');
-INSERT INTO nulltest values ('a', NULL, 'c', 'd');
-INSERT INTO nulltest values ('a', 'b', NULL, 'd');
-INSERT INTO nulltest values ('a', 'b', 'c', NULL); -- Good
-select * from nulltest;
-
-
-create domain ddef1 int4 DEFAULT 3;
-create domain ddef2 numeric(8,6) DEFAULT '1234.123456789';
--- Type mixing, function returns int8
-create domain ddef3 text DEFAULT 5;
-create sequence ddef4_seq;
-create domain ddef4 int4 DEFAULT nextval(cast('ddef4_seq' as text));
-
-create table defaulttest
-            ( col1 ddef1
-            , col2 ddef2
-            , col3 ddef3
-            , col4 ddef4
-            , col5 ddef1 NOT NULL DEFAULT NULL
-            , col6 ddef2 DEFAULT '88.1'
-            , col7 ddef4 DEFAULT 8000
-            );
-insert into defaulttest default values;
-insert into defaulttest default values;
-insert into defaulttest default values;
-select * from defaulttest;