Home > mailing lists

Re: CREATE TABLE AS and ORDER BY - Mailing list pgsql-sql

From	Tom Lane
Subject	Re: CREATE TABLE AS and ORDER BY
Date	February 6, 2001 14:05:35
Msg-id	25163.981475515@sss.pgh.pa.us Whole thread Raw
In response to	CREATE TABLE AS and ORDER BY (Joy Chuang <hxc0850@omega.uta.edu>)
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: "Sebastian"
Date: 06 February 2001, 13:01:42
Subject: Re: Search

From: Tom Lane
Date: 06 February 2001, 14:16:14
Subject: Re: PL/PGSQL function with parameters

Re: CREATE TABLE AS and ORDER BY - Mailing list pgsql-sql

Previous

Next