Alphabetical sorting...
| От | Chris Johnson |
|---|---|
| Тема | Alphabetical sorting... |
| Дата | |
| Msg-id | Pine.LNX.3.96.980706153810.3242B-100000@boreus.bedfo.ma.tiac.net обсуждение исходный текст |
| Ответ на | Varchar and varchar2 (Jeffrey Napolitano <jnapoli@setech.com>) |
| Ответы |
Re: [GENERAL] Alphabetical sorting...
|
| Список | pgsql-general |
HELP!
Alphabetical sorting... is it broken or is this intentional. If this is
not a "feature" anyone have any idea of how to actually sort
alphabetically on a text field?
cmj=> create table test (test text);
CREATE
cmj=> insert into test values ('a');
INSERT 240009 1
cmj=> insert into test values ('A');
INSERT 240010 1
cmj=> insert into test values ('ABLE');
INSERT 240011 1
cmj=> insert into test values ('Able');
INSERT 240012 1
cmj=> insert into test values ('AXIOM');
INSERT 240013 1
select * from test order by test;
test
-----
A
ABLE
AXIOM
Able
a
(5 rows)
Thanks!
Chris
В списке pgsql-general по дате отправления: