Re: CREATE TABLE AS and ORDER BY

Joy Chuang <hxc0850@omega.uta.edu> 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