lexicographical ordering in postgres

Поиск
Список
Период
Сортировка
От Paramveer.Singh@trilogy.com
Тема lexicographical ordering in postgres
Дата
Msg-id OF787E552C.DB28019E-ONE5256F11.002D9B31@trilogy.com
обсуждение исходный текст
Ответы Re: lexicographical ordering in postgres
Список pgsql-general
Hi!
I created a table in postgres with varchar values in it, and I noticed that
postgres lexicographical ordering is weird in the sense that it ignores
whitespaces.
please look at the result I got:

select * from tablename order by columnname;
            cloumnname
      -------------------------------------
            one 1
            one  1
            one 12
            one 2
            one 30
      (5 rows)
      This means that 'one<space>1' and 'one<space><space>1' are the same
lexicographically.
Is this correct?
thanks
paraM



В списке pgsql-general по дате отправления: