[SQL] CREATE TABLE AS and ORDER BY

[Joy Chuang]

Hi,

I tried to use CREATE TABLE AS and ORDER BY.  The query is as followed:

create table freshhr21 as
select e.studentid, u.hoursxfer
from enrollmentstatus e, undergradclass u
where e.studentid = u.studentid and e.classtd = '1'
order by u.hoursxfer

But, it returns error message "ERROR:  parser: parse error at or near
"order"".  Does "create table as" support "order by" inside of it?

I am using PostgreSQL 6.5.3.

Thank you.

Joy Chuang