On Tue, 2005-05-10 at 11:41 +0200, Julian Legeny wrote:
> ...
> But I would like to sort all data as following:
>
> NAME
> -----------
> AAA
> aaa
> BBB
> bbb
> CCC
> ccc
> How can I write sql command (or set up ORDER BY options) for selecting that?
how about ORDER BY lower(NAME),NAME ?
gnari
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
