[GENERAL] CREATE TABLE AS... syntax?

[Dr. Evil]

I'm trying to use CREATE TABLE AS under 7.03.  There are no
examples in the guide, so I tried a few things:

CREATE TABLE foo (test INT4) AS SELECT number FROM account; 

and

CREATE TABLE foo (test INT4) AS number FROM account; 

and both of them give ERROR:  parser: parse error at or near "as".
Any tips on how to use this?

Thanks

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]