pgsql: Add more tests for CREATE TABLE AS with WITH NO DATA

Add more tests for CREATE TABLE AS with WITH NO DATA

The relation creation is done at executor startup, however the main
regression test suite is lacking scenarios where no data is inserted
which is something that can happen when using EXECUTE or EXPLAIN with
CREATE TABLE AS and WITH NO DATA.

Some patches are worked on to reshape the way CTAS relations are
created, so this makes sure that we do not miss some query patterns
already supported.

Reported-by: Andreas Karlsson
Author: Michael Paquier
Reviewed-by: Andreas Karlsson
Discussion: https://postgr.es/m/20190206091817.GB14980@paquier.xyz

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/537898bd81bd8bd3650846e0abde4298ff1373da

Modified Files
--------------
src/test/regress/expected/prepare.out     | 7 +++++++
src/test/regress/expected/select_into.out | 7 ++++---
src/test/regress/sql/prepare.sql          | 3 +++
src/test/regress/sql/select_into.sql      | 7 ++++---
4 files changed, 18 insertions(+), 6 deletions(-)