|
Hi! New to the list with a question that I cannot find the answer to in the manual or on the internet but I suspect is trivial. If somebody could point me in the correct direction I would be greatful. This is what I do (condensed, of course): # create table tmp ( x text ) ; CREATE TABLE # insert into tmp(x) values ('a'),('c'),('-b') ; INSERT 0 3 # select * from tmp order by x ; x ---- a -b c (3 rows) I would expect a string that start with a hyphen to be sorted before or after 'a' and 'c' and not between them. I have tried with a few other characters (space, opening parenthesis, etc) but the result is the same. What I want is the strings sorted by their ascii (or UTF-8) values, without some "smart" heuristic. How do I accomplish this? I cannot find this described in the manual (it should be there!) or on the net. /Fredric PS. 8.2, Fedora Linux |
begin:vcard fn:Fredric Fredricson n:Fredricson;Fredric org:Ln4 Solutions AB email;internet:Fredric.Fredricson@xxxxxxxxxxxxx title:CTO tel;home:+46 8 91 64 39 tel;cell:+46 70 677 58 48 version:2.1 end:vcard
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
