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