Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.3/8.9.3) with SMTP id EAA21519 for ; Wed, 2 Jun 1999 04:39:25 -0400 (EDT) (envelope-from wieck@debis.com) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@postgreSQL.org id m10p6W9-0003kGC; Wed, 2 Jun 99 10:36 MET DST Message-Id: From: wieck@debis.com (Jan Wieck) Subject: Re: [SQL] Order by To: michaely@alphanet.net.au (Michael Yeung) Date: Wed, 2 Jun 1999 10:36:57 +0200 (MET DST) Cc: pgsql-sql@postgreSQL.org Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: <000d01beac91$92bdf2f0$0c01a8c0@quay> from "Michael Yeung" at Jun 2, 99 10:48:04 am X-Mailer: ELM [version 2.4 PL25] Content-Type: text > > 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 ? ORDER BY (along with many other things on views) is on my personal TODO. I hope to get it working in v6.6. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #======================================== jwieck@debis.com (Jan Wieck) #