Re: [GENERAL] "CREATE TABLE table_name AS EXECUTE name WITH DATA" becomes syntax error.

Naoya Anzai writes: > 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. Hmm ... it looks like WITH [NO] DATA is actually only implemented

Re: [GENERAL] "CREATE TABLE table_name AS EXECUTE name WITH DATA" becomes syntax error.

On Thursday, November 24, 2011 1:55:53 am Naoya Anzai wrote: > 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 specifi

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

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();