"Dr. Evil" wrote:
>
> 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?
I think you want:
CREATE TABLE foo AS SELECT number AS test FROM account;
Calvin
--
Calvin Dodge
Certified Linux Bigot (tm)
http://www.caldodge.fpcc.net
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
