Received: from bridge.private.alphanet.net.au (bridge.alphanet.net.au
	[203.23.58.14]) by hub.org (8.9.3/8.9.3) with ESMTP id WAA76582
	for <pgsql-sql@postgreSQL.org>; Tue, 1 Jun 1999 22:08:29 -0400 (EDT)
	(envelope-from michaely@alphanet.net.au)
Received: (from shutdown@localhost)
	by bridge.private.alphanet.net.au (8.8.7/8.8.7) id LAA13577
	for <pgsql-sql@postgreSQL.org>; Wed, 2 Jun 1999 11:12:37 +1000
X-Authentication-Warning: bridge.private.alphanet.net.au: shutdown set sender
	to <michaely@alphanet.net.au> using -f
Received: from dhcp02.private.alphanet.net.au(192.168.1.12) by
	bridge.private.alphanet.net.au via smap (V1.3)
	id sma013575; Wed Jun  2 01:12:33 1999
Message-ID: <000d01beac91$92bdf2f0$0c01a8c0@quay>
From: "Michael Yeung" <michaely@alphanet.net.au>
To: "pgsql SQL" <pgsql-sql@postgreSQL.org>
Subject: Order by
Date: Wed, 2 Jun 1999 10:48:04 +1000
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

Hi all,

Is anyone know that if we allow order-by clause in the view structure.
If not, how can we take the ordering of the UNION ALL in 2 different bags ?

Thanks!!

MICHAEL