Re: [SQL] desc and asc

From: "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it>
To: Mike Lemler <coronach(at)datacruz(dot)com>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] desc and asc
Date: 1998-06-04 10:26:50
Message-ID: Pine.LNX.3.96.980604102626.945E-100000@proxy.bazzanese.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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'

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jose' Soares Da Silva 1998-06-04 10:30:59 Re: [SQL] problems with CAST :-{
Previous Message Jose' Soares Da Silva 1998-06-04 10:23:52 Re: [SQL] Money Data Type