From: | spam(at)freeuk(dot)com (Stephen Patterson) |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | case insensitive sort for output from SELECT |
Date: | 2001-05-16 19:21:22 |
Message-ID: | slrn9g5gva.9il.spam@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Is there any way to alphabetically sort the output of a select
statement correctly?
what I'm using at the moment is
SELECT data FROM table ORDER BY DATA ASC
which gives (for example)
A
B
C
a
b
Is there any way to rig this so that it sorts 'properly', i.e. both
the a's come together?
Given what I'm working on, I could use either a pure SQL solution or
some perl to put around the perl DBI.
--
It's a great big universe and we're all really puny, just tiny little specks
'bout the size of Mickey Rooney -- Animaniacs
-- -- -- -- -- -- -- -- -- --
Stephen Patterson s(dot)patterson(at)SPAMOFFfreeuk(dot)com (Remove SPAMOFF to reply)
http://home.freeuk.net/s.patterson/
From | Date | Subject | |
---|---|---|---|
Next Message | G. Anthony Reina | 2001-05-16 19:43:29 | "avg" function for arrays? |
Previous Message | Edwin S. Ramirez | 2001-05-16 17:30:40 | Help! Record logging |