Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f16G5Wx06203 for ; Tue, 6 Feb 2001 11:05:32 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f16G5F925166; Tue, 6 Feb 2001 11:05:15 -0500 (EST) To: Joy Chuang cc: pgsql-sql@postgresql.org Subject: Re: CREATE TABLE AS and ORDER BY In-reply-to: <3A7F5AF9.B23DF42F@omega.uta.edu> References: <3A7F5AF9.B23DF42F@omega.uta.edu> Comments: In-reply-to Joy Chuang message dated "Mon, 05 Feb 2001 20:01:30 -0600" Date: Tue, 06 Feb 2001 11:05:15 -0500 Message-ID: <25163.981475515@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200102/84 X-Sequence-Number: 1262 Joy Chuang 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