Received: from proxy.bazzanese.com (root@ip135.tol11.interbusiness.it [195.120.106.135]) by hub.org (8.8.8/8.7.5) with ESMTP id FAA05819 for ; Thu, 4 Jun 1998 05:17:31 -0400 (EDT) Received: from localhost (sferac@localhost) by proxy.bazzanese.com (8.8.8/8.8.8/Debian/GNU) with SMTP id KAA01040; Thu, 4 Jun 1998 10:26:50 GMT Date: Thu, 4 Jun 1998 10:26:50 +0000 (UTC) From: "Jose' Soares Da Silva" X-Sender: sferac@proxy.bazzanese.com To: Mike Lemler cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] desc and asc In-Reply-To: <3.0.5.32.19980603120845.007a5850@datacruz.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Wed, 3 Jun 1998, Mike Lemler wrote: > The nifty little booklet I have that tells the the ANSI SQL92 standard for > desc and asc seems not to work with order by. Could some one post an example? > > Thanks hygea=> select * from prova order by testo asc; testo ----- ALFA BETA ZEBRA ZETA zebra (5 rows) hygea=> select * from prova order by testo desc; testo ----- zebra ZETA ZEBRA BETA ALFA (5 rows) Jose'