"CREATE TABLE table_name AS EXECUTE name WITH DATA" becomes syntax error.

From: Naoya Anzai <anzai-naoya(at)mxu(dot)nes(dot)nec(dot)co(dot)jp>
To: pgsql-general(at)postgresql(dot)org
Cc: Akio Iwaasa <iwaasa(at)mxs(dot)nes(dot)nec(dot)co(dot)jp>
Subject: "CREATE TABLE table_name AS EXECUTE name WITH DATA" becomes syntax error.
Date: 2011-11-24 09:55:53
Message-ID: 52CCAA8F414BA8anzai-naoya@mxu.nes.nec.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Antonio Franzoso 2011-11-24 11:37:52 Re: Compiler does not detect support for 64 bit integers
Previous Message Tom Lane 2011-11-24 03:10:25 Re: plpgsql Difference in behaviour between versions?