Received: from relay04.esat.net (relay04.esat.net [192.111.39.47]) by hub.org (8.10.1/8.10.1) with ESMTP id e58EdMT52056 for ; Thu, 8 Jun 2000 10:39:23 -0400 (EDT) Received: from (ebeon.com) [193.120.161.91] by relay04.esat.net with esmtp id 1303Sm-0003UN-00; Thu, 08 Jun 2000 15:39:16 +0100 Message-ID: <393FBEBC.B2F8A691@ebeon.com> Date: Thu, 08 Jun 2000 16:41:48 +0100 From: Niall Smart X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.12 i386) X-Accept-Language: en MIME-Version: 1.0 To: Michael Ansley CC: pgsql-sql@postgresql.org Subject: Re: ORDER BY in definition of views References: <2D50E16224C8D311B183009027452B476AFC90@INTEC003> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/91 Michael Ansley wrote: > > Would there be a particular reason to do this? > I like to define views for lookups (i.e. job titles, departments, accounts, whatever). It would be nice if I could just do a select * from whatever_vw instead of having to remember to put the order by whatever_name clause. Admittedly its no biggie, but it is nice-to-have. Niall