General Bug Report: CREATE TABLE AS doesn't work

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Marinos Yannikos
Your email address : mjy(at)pobox(dot)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 :-)

--------------------------------------------------------------------------