ORDER BY Problem

From: Rodolphe QUIEDEVILLE <rodolphe(at)ecila(dot)fr>
To: "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org>
Subject: ORDER BY Problem
Date: 1999-12-15 09:30:22
Message-ID: 38575FAE.D0BE3C8@ecila.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi see this :

test=> select ch from test order by ch ;
ch
----------
aa (1)
bb
cc
-- cc -- (2)
dd
-- vv --
www
{www} (3)
zz
(9 rows)

test=>

My problem is I want the line (2) appears in first and the line (3) in
last. I'm not found an answer to my problem in docs. So please help and
explain to me how to configure correctly the sort.

Thanks.

I'm using the 6.5.3 version of Pg on RH 6.1.
Thanks again

--
Rodolphe QUIEDEVILLE
ECILA : http://www.ecila.fr/
rodolphe(at)ecila(dot)fr

Browse pgsql-general by date

  From Date Subject
Next Message Catharina Paulsen 1999-12-15 10:58:01 Postgres with PHP
Previous Message Lincoln Spiteri 1999-12-15 08:31:37 Re: [GENERAL] Fw: Spin lock error