summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/create_misc.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/sql/create_misc.sql')
-rw-r--r--src/test/regress/sql/create_misc.sql5
1 files changed, 2 insertions, 3 deletions
diff --git a/src/test/regress/sql/create_misc.sql b/src/test/regress/sql/create_misc.sql
index a4cb816fa0..40c9b417d9 100644
--- a/src/test/regress/sql/create_misc.sql
+++ b/src/test/regress/sql/create_misc.sql
@@ -6,12 +6,11 @@
-- (any resemblance to real life is purely coincidental)
--
-INSERT INTO tenk2 VALUES (tenk1.*);
+INSERT INTO tenk2 SELECT * FROM tenk1;
SELECT * INTO TABLE onek2 FROM onek;
-
-INSERT INTO fast_emp4000 VALUES (slow_emp4000.*);
+INSERT INTO fast_emp4000 SELECT * FROM slow_emp4000;
SELECT *
INTO TABLE Bprime