lexicographical ordering in postgres - Mailing list pgsql-general

From Paramveer.Singh@trilogy.com
Subject lexicographical ordering in postgres
Date
Msg-id OF787E552C.DB28019E-ONE5256F11.002D9B31@trilogy.com
Whole thread Raw
Responses Re: lexicographical ordering in postgres  (Martijn van Oosterhout <kleptog@svana.org>)
List 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 by date:

Previous
From: Paramveer.Singh@trilogy.com
Date:
Subject: Re: schema level variables
Next
From: "m.b."
Date:
Subject: Stemmer integration in tsearch2 / $libdir error