diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2003-07-01 00:04:31 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2003-07-01 00:04:31 +0000 |
| commit | 71e9f3b07f2f993492233dc2fff0566acc70eb64 (patch) | |
| tree | bf63ec576f78d03eeb72a181ac0d47554e695358 /src/test/regress/expected/prepare.out | |
| parent | df08f5c0030590980a203b72cdfdba817ff95b30 (diff) | |
| download | postgresql-71e9f3b07f2f993492233dc2fff0566acc70eb64.tar.gz | |
Change EXECUTE INTO to CREATE TABLE AS EXECUTE.
Diffstat (limited to 'src/test/regress/expected/prepare.out')
| -rw-r--r-- | src/test/regress/expected/prepare.out | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/prepare.out b/src/test/regress/expected/prepare.out index 629e444fb7..04ab65b718 100644 --- a/src/test/regress/expected/prepare.out +++ b/src/test/regress/expected/prepare.out @@ -80,10 +80,10 @@ ERROR: Parameter $3 of type boolean cannot be coerced into the expected type do -- invalid type PREPARE q4(nonexistenttype) AS SELECT $1; ERROR: Type "nonexistenttype" does not exist --- execute into +-- create table as execute PREPARE q5(int, text) AS SELECT * FROM tenk1 WHERE unique1 = $1 OR stringu1 = $2; -EXECUTE q5(200, 'DTAAAA') INTO TEMPORARY q5_prep_results; +CREATE TEMPORARY TABLE q5_prep_results AS EXECUTE q5(200, 'DTAAAA'); SELECT * FROM q5_prep_results; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 ---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+--------- |