9961 | 2058 | 1 | 1 | 1 | 1 | 61 | 961 | 1961 | 4961 | 9961 | 122 | 123 | DTAAAA | EBDAAA | OOOOxx

(16 rows)

CREATE TEMPORARY TABLE q5_prep_nodata AS EXECUTE q5(200, 'DTAAAA')

WITH NO DATA;

SELECT * FROM q5_prep_nodata;

unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4

---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------

(0 rows)

-- unknown or unspecified parameter types: should succeed

PREPARE q6 AS

SELECT * FROM tenk1 WHERE unique1 = $1 AND stringu1 = $2;

4567890123456789 | -4567890123456789

(5 rows)

-- Try EXPLAIN ANALYZE SELECT INTO, but hide the output since it won't

-- be stable.

-- Try EXPLAIN ANALYZE SELECT INTO and EXPLAIN ANALYZE CREATE TABLE AS

--WITH NO DATA, but hide the outputs since they won'tbe stable.

DO $$

BEGIN

EXECUTE 'EXPLAIN ANALYZE SELECT * INTO TABLE easi FROM int8_tbl';

EXECUTE 'EXPLAIN ANALYZE CREATE TABLE easi2 AS SELECT * FROM int8_tbl WITH NO DATA';

END$$;

DROP TABLE created_table;

DROP TABLE easi;

DROP TABLE easi, easi2;

--

-- Disallowed uses of SELECT ... INTO. All should fail

--

ORDER BY unique1;

CREATE TEMPORARY TABLE q5_prep_resultsAS EXECUTE q5(200,'DTAAAA');

SELECT*FROM q5_prep_results;

CREATE TEMPORARY TABLE q5_prep_nodataAS EXECUTE q5(200,'DTAAAA')

WITH NO DATA;

SELECT*FROM q5_prep_nodata;

PREPARE q6AS

SELECT*FROM created_table;

DO $$

EXECUTE'EXPLAIN ANALYZE SELECT * INTO TABLE easi FROM int8_tbl';

EXECUTE'EXPLAIN ANALYZE CREATE TABLE easi2 AS SELECT * FROM int8_tbl WITH NO DATA';

END$$;

DROPTABLE created_table;

DROPTABLE easi;

DROPTABLE easi, easi2;