"CREATE TABLE table_name AS EXECUTE name WITH DATA" becomes syntax error. - Mailing list pgsql-general

From Naoya Anzai
Subject "CREATE TABLE table_name AS EXECUTE name WITH DATA" becomes syntax error.
Date
Msg-id 52CCAA8F414BA8anzai-naoya@mxu.nes.nec.co.jp
Whole thread Raw
Responses Re: "CREATE TABLE table_name AS EXECUTE name WITH DATA" becomes syntax error.  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: "CREATE TABLE table_name AS EXECUTE name WITH DATA" becomes syntax error.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

Accroding to http://www.postgresql.org/docs/9.1/interactive/sql-createtableas.html ,
"CREATE TABLE table_name AS EXECUTE name WITH DATA" seems a right syntax,
but,this statement becomes a SYNTAX ERROR.
Is this a specification?
---
naoya=# SELECT VERSION();
                                                    version
---------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.1.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48), 64-bit
(1 row)

naoya=# PREPARE GETONE AS SELECT * FROM SEED WHERE ID=1;
PREPARE

naoya=# EXECUTE GETONE;
 id |            date
----+----------------------------
  1 | 2011-11-24 11:24:49.675427
(1 row)

naoya=# CREATE TABLE NEW_SEED AS EXECUTE GETONE;
SELECT 1

naoya=# CREATE TABLE NEW_SEED2 AS EXECUTE GETONE WITH DATA;
ERROR:  syntax error at or near "WITH DATA" at character 42
STATEMENT:  CREATE TABLE NEW_SEED2 AS EXECUTE GETONE WITH DATA;
---

Regards.


---
Naoya Anzai

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: plpgsql Difference in behaviour between versions?
Next
From: Phoenix Kiula
Date:
Subject: Re: Installed. Now what?