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