peter pilsl wrote:

I just get my mind crossed here:

I do a simple select with order on a text-type. In my opinion entries with leading spaces should be either first (or maybe last) in the list.
But in my select the whitespace just seems to be ignored:

That'll be down to your locale settings. You'll need to re-initdb to change them I'm afraid. It's locale=C that you want.

--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to