Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f16DBRx75166 for ; Tue, 6 Feb 2001 08:11:27 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from ns2.uta.edu (ns2.uta.edu [129.107.1.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f161h5x95843 for ; Mon, 5 Feb 2001 20:43:06 -0500 (EST) (envelope-from hxc0850@omega.uta.edu) Received: from omega.uta.edu ([129.107.100.101]) by ns2.uta.edu (8.10.0/8.10.0) with ESMTP id f161gxF01429 for ; Mon, 5 Feb 2001 19:42:59 -0600 (CST) Message-ID: <3A7F5AF9.B23DF42F@omega.uta.edu> Date: Mon, 05 Feb 2001 20:01:30 -0600 From: Joy Chuang X-Mailer: Mozilla 4.5 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: CREATE TABLE AS and ORDER BY Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/78 X-Sequence-Number: 1254 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