Received: from shaked.cc.openu.ac.il (shaked.cc.openu.ac.il [147.233.145.65]) by hub.org (8.8.8/8.7.5) with ESMTP id NAA08631 for ; Wed, 3 Jun 1998 13:35:50 -0400 (EDT) Received: from [147.233.159.109] (herouth@mac-herouth.pc.openu.ac.il [147.233.159.109]) by shaked.cc.openu.ac.il (8.8.5/8.8.5) with ESMTP id UAA13198; Wed, 3 Jun 1998 20:35:32 +0300 (IDT) X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <3.0.5.32.19980603120845.007a5850@datacruz.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Wed, 3 Jun 1998 20:36:34 +0300 To: coronach@datacruz.com (Mike Lemler), pgsql-sql@postgreSQL.org From: Herouth Maoz Subject: Re: [SQL] desc and asc At 20:08 +0300 on 3/6/98, 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? Sure: testing=> SELECT engterm FROM glossary testing-> WHERE dict=1 AND engterm IS NOT NULL testing-> ORDER BY engterm ASC; engterm ------- Mafia Stereo change geek green plasma stam (7 rows) testing=> SELECT engterm FROM glossary testing-> WHERE dict=1 AND engterm IS NOT NULL testing-> ORDER BY engterm DESC; engterm ------- stam plasma green geek change Stereo Mafia (7 rows) Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma