Обсуждение: ORDER BY Problem

Поиск
Список
Период
Сортировка

ORDER BY Problem

От
Rodolphe QUIEDEVILLE
Дата:
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