Re: select statement sorting

[Nick Barr <nicky@chuckie.co.uk>]

Alexander Cohen wrote:

> is it possible to have postgres return a "SELECT * FROM table ORDER BY 
> table_column" query that is not case sensitive order?
>
> if i have these words in a column:
>
> Alex
> alex
> Barbara
> Cohen
>
> i will get them back in the following order in the tuples:
>
> Alex
> Barbara
> Cohen
> alex
>
> But i want them back likke this:
>
> Alex
> alex
> Barbara
> Cohen
>
> Is this possible or do i need to sort them myself after the query 
> returns?
>
> Also, i noticed that postgres will let me create groups, databases and 
> users with spaces in their names, is this ok or should i check this 
> beforehand and not allow this?
>
> thanks!
Try

SELECT * FROM table ORDER BY LOWER(table_column);

or of course

SELECT * FROM table ORDER BY UPPER(table_column);


Nick



---------------------------(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