Check your locale settings. The en_US locale sorts like that for
example...
On Thu, Sep 16, 2004 at 04:00:43AM -0500, [EMAIL PROTECTED] wrote:
> 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 ignor
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
--
