Re: [SQL] CREATE TABLE AS and ORDER BY

[Tom Lane]

Joy Chuang <[EMAIL PROTECTED]> writes:
> But, it returns error message "ERROR:  parser: parse error at or near
> "order"".  Does "create table as" support "order by" inside of it?

Evidently not.

> I am using PostgreSQL 6.5.3.

It seems to work in 7.0 and later.

                        regards, tom lane