summaryrefslogtreecommitdiff
path: root/src/test/suite/select.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/suite/select.sql')
-rw-r--r--src/test/suite/select.sql31
1 files changed, 0 insertions, 31 deletions
diff --git a/src/test/suite/select.sql b/src/test/suite/select.sql
deleted file mode 100644
index 5ede1dc159..0000000000
--- a/src/test/suite/select.sql
+++ /dev/null
@@ -1,31 +0,0 @@
----------------------------------------------------------------------------
---
--- select.sql-
--- test select
---
---
--- Copyright (c) 1994-5, Regents of the University of California
---
--- $Id: select.sql,v 1.1.1.1 1996/07/09 06:22:30 scrappy Exp $
---
----------------------------------------------------------------------------
-
--- test Result nodes (constant target list/quals)
-select 1 as X;
-create table foo (name char16, salary int4);
-insert into foo values ('mike', 15000);
-select * from foo where 2 > 1;
-select * from pg_class where 1=0;
-
--- test select distinct
-create table bar (x int4);
-insert into bar values (1);
-insert into bar values (2);
-insert into bar values (1);
-select distinct * from bar;
-select distinct * into table bar2 from bar;
-select distinct * from bar2;
-
-drop table foo;
-drop table bar;
-drop table bar2;