Thread: ORDER BY Problem

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