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
