From: | Alexander Cohen <alex(at)toomuchspace(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | select statement sorting |
Date: | 2004-03-31 15:31:43 |
Message-ID: | 835C896C-8328-11D8-B96A-000A95B947DC@toomuchspace.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | mlists | 2004-03-31 15:36:12 | How can I change type of column |
Previous Message | Tom Lane | 2004-03-31 15:21:48 | Re: Warings in Log: could not resolve "localhost": host nor service provided, or not known |