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: 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 ________________________________________________________________________ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
