============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Marinos Yannikos
Your email address : mjy@pobox.com
Category : runtime: back-end: SQL
Severity : serious
Summary: CREATE TABLE AS doesn't work
System Configuration
--------------------
Operating System : Linux 2.2.9
PostgreSQL version : 6.5.0
Compiler used : egcs-1.1.1 release
Hardware:
---------
Linux XXX 2.2.9 #11 Sat Jun 12 04:23:30 MEST 1999 i686 unknown
Celeron 300A 192MB, EIDE system
Versions of other tools:
------------------------
--------------------------------------------------------------------------
Problem Description:
--------------------
The CREATE TABLE AS syntax doesn't work the way it is described in the manual:
*******************************************************************************
QUERY: create table xxx (foo int4) as select 1;
*******************************************************************************
press return to continue ..
ERROR: parser: parse error at or near "as"
--------------------------------------------------------------------------
Test Case:
----------
see above
--------------------------------------------------------------------------
Solution:
---------
Implement it :-)
--------------------------------------------------------------------------