you can do a lower on it to remove the case sensitivity.
select * from table order by lower(table_column) asc
-----Original Message-----
From: Alexander Cohen [mailto:alex@toomuchspace.com]
Sent: 31 March 2004 16:32
To: pgsql-general@postgresql.org
Subject: [GENERAL] select statement sorting
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!
--
Alexander Cohen
http://www.toomuchspace.com
(819) 348-9237
(819) 432-3443
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________