Re: [SQL] desc and asc

From: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
To: coronach(at)datacruz(dot)com (Mike Lemler), pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] desc and asc
Date: 1998-06-03 17:36:34
Message-ID: l03110706b19b3932e525@[147.233.159.109]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stoeppel 1998-06-03 19:39:00 problems with CAST :-{
Previous Message Mike Lemler 1998-06-03 17:08:45 desc and asc