diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2000-11-24 17:14:07 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2000-11-24 17:14:07 +0000 |
| commit | 4cbeefb1e8a862d5fd4f3587125338765951d74d (patch) | |
| tree | 32ee691ddc066690135790825cdb93c11f201753 /src/test/suite/varchar.sql | |
| parent | 80dab5bd69cd5bcd064a7da9f3d1b22eb770925a (diff) | |
| download | postgresql-4cbeefb1e8a862d5fd4f3587125338765951d74d.tar.gz | |
Remove obsolete test suite
Diffstat (limited to 'src/test/suite/varchar.sql')
| -rw-r--r-- | src/test/suite/varchar.sql | 64 |
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; |
