problem with ORDER BY
| От | Nicolas KOWALSKI |
|---|---|
| Тема | problem with ORDER BY |
| Дата | |
| Msg-id | 873asd7zzk.fsf@petole.dyndns.org обсуждение исходный текст |
| Ответы |
Re: problem with ORDER BY
|
| Список | pgsql-general |
Hello,
I do not understand why the following ORDER BY statment does not work
as I would expect:
1) I defined a simple table with only one column, containing urls:
mon=> \d url
Table "public.url"
Column | Type | Modifiers
--------+------+-----------
url | text | not null
Indexes:
"url_pkey" primary key, btree (url)
2) I populated it, some urls starting with https, others with http
3) When I want to sort them, I get this "strange" ordering:
mon=> SELECT * FROM url ORDER BY url asc ;
url
-------------------------------
http://imag.fr/
https://gmail.com/
https://mail.google.com/mail/
https://www.sixxs.net/
http://www.google.com/
http://www.google.com/reader/
http://www.google.fr/
http://www.postgresql.org/
(8 rows)
Should'nt I get these values in the following order ?
http://imag.fr/
http://www.google.com/
http://www.google.com/reader/
http://www.google.fr/
http://www.postgresql.org/
https://gmail.com/
https://mail.google.com/mail/
https://www.sixxs.net/
Thanks,
--
Nicolas
В списке pgsql-general по дате отправления: