Remove gratuitous uses of deprecated SELECT INTO
authorPeter Eisentraut <peter@eisentraut.org>
Thu, 28 Jan 2021 13:01:41 +0000 (14:01 +0100)
committerPeter Eisentraut <peter@eisentraut.org>
Thu, 28 Jan 2021 13:28:41 +0000 (14:28 +0100)
commitb034ef9b376dbe712caa076541d6a750f37d85ce
tree82a37fb7223d96af0bbda527d306829fa0504cf1
parent6c5576075b0f93f2235ac8a82290fe3b6e82300d
Remove gratuitous uses of deprecated SELECT INTO

CREATE TABLE AS has been preferred over SELECT INTO (outside of ecpg
and PL/pgSQL) for a long time.  There were still a few uses of SELECT
INTO in tests and documentation, some old, some more recent.  This
changes them to CREATE TABLE AS.  Some occurrences in the tests remain
where they are specifically testing SELECT INTO parsing or similar.

Discussion: https://www.postgresql.org/message-id/flat/96dc0df3-e13a-a85d-d045-d6e2c85218da%40enterprisedb.com
15 files changed:
contrib/sepgsql/expected/label.out
contrib/sepgsql/sql/label.sql
doc/src/sgml/hstore.sgml
src/bin/pg_basebackup/t/010_pg_basebackup.pl
src/bin/pg_checksums/t/002_actions.pl
src/test/regress/expected/create_index.out
src/test/regress/expected/create_misc.out
src/test/regress/expected/random.out
src/test/regress/expected/select_implicit.out
src/test/regress/expected/select_implicit_1.out
src/test/regress/expected/select_implicit_2.out
src/test/regress/sql/create_index.sql
src/test/regress/sql/create_misc.sql
src/test/regress/sql/random.sql
src/test/regress/sql/select_implicit.sql