diff options
| author | Bruce Momjian <bruce@momjian.us> | 2000-06-04 17:52:54 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2000-06-04 17:52:54 +0000 |
| commit | 54bce381a7b4802b7516de7876e026e757779235 (patch) | |
| tree | 0912fe417272d4273c8e7c74f99f8b73b8d43e29 | |
| parent | 0a54de8fafeb32b9524d48e9abf519933c62c690 (diff) | |
| download | postgresql-54bce381a7b4802b7516de7876e026e757779235.tar.gz postgresql-54bce381a7b4802b7516de7876e026e757779235.zip | |
Remove FROM warning by fixing query.
| -rw-r--r-- | src/test/regress/expected/select_into.out | 7 | ||||
| -rw-r--r-- | src/test/regress/sql/select_into.sql | 4 |
2 files changed, 4 insertions, 7 deletions
diff --git a/src/test/regress/expected/select_into.out b/src/test/regress/expected/select_into.out index 5c550ced7a9..503efe04fc2 100644 --- a/src/test/regress/expected/select_into.out +++ b/src/test/regress/expected/select_into.out @@ -3,14 +3,11 @@ -- SELECT * INTO TABLE tmp1 - FROM tmp + FROM onek WHERE onek.unique1 < 2; -NOTICE: Adding missing FROM-clause entry for table onek DROP TABLE tmp1; SELECT * INTO TABLE tmp1 - FROM tmp + FROM onek2 WHERE onek2.unique1 < 2; DROP TABLE tmp1; -NOTICE: Adding missing FROM-clause entry for table onek - diff --git a/src/test/regress/sql/select_into.sql b/src/test/regress/sql/select_into.sql index 91214512acf..993c44b727d 100644 --- a/src/test/regress/sql/select_into.sql +++ b/src/test/regress/sql/select_into.sql @@ -4,14 +4,14 @@ SELECT * INTO TABLE tmp1 - FROM tmp + FROM onek WHERE onek.unique1 < 2; DROP TABLE tmp1; SELECT * INTO TABLE tmp1 - FROM tmp + FROM onek2 WHERE onek2.unique1 < 2; DROP TABLE tmp1; |