Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28])
	by postgresql.org (8.11.3/8.11.1) with SMTP id f3DMkl840137
	for <pgsql-general@postgresql.org>;
	Fri, 13 Apr 2001 18:46:47 -0400 (EDT)
	(envelope-from pgsql-general-owner@postgresql.org)
Received: from news.tht.net (news.hub.org [216.126.91.242])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f3B8tQ801132
	for <pgsql-general@postgresql.org>;
	Wed, 11 Apr 2001 04:55:27 -0400 (EDT)
	(envelope-from news@news.tht.net)
Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id
 f3B8PpK39109
	for pgsql-general@postgresql.org; Wed, 11 Apr 2001 04:25:51 -0400 (EDT)
	(envelope-from news)
From: "Marcin Wasilewski" <marcingrupy@poczta.onet.pl>
X-Newsgroups: comp.databases.postgresql.questions
Subject: Order in CREATE VIEW
Date: Wed, 11 Apr 2001 10:25:24 +0200
Organization: tp.internet - http://www.tpi.pl
Lines: 16
Message-ID: <9b148t$l66$1@news.tpi.pl>
X-Complaints-To: usenet@tpi.pl
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MSMail-Priority: Normal
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
To: pgsql-general@postgresql.org
X-Archive-Number: 200104/550
X-Sequence-Number: 7691

hello everybody,
Can you help me?

I have POSTGRESQL 7.0.3,
I try to create simple view by typing.

create view "xx" as select "aa.yy", "bb.yy" from "yy" order by "bb.yy"

the problem is that parameter order is not implemented with create view.
so how can I create such simple query??

Best regards
Marcin