ORDER BY Problem - Mailing list pgsql-general

From Rodolphe QUIEDEVILLE
Subject ORDER BY Problem
Date
Msg-id 38575FAE.D0BE3C8@ecila.fr
Whole thread Raw
List 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@ecila.fr

pgsql-general by date:

Previous
From: Lincoln Spiteri
Date:
Subject: Re: [GENERAL] Fw: Spin lock error
Next
From: Wim Ceulemans
Date:
Subject: Re: [GENERAL] Re: Installation problem on Suse linux 6.3