Re: Oder by not working

"Blanco, Jose" <blancoj(at)umich(dot)edu> writes:
> Suppose we have the following 3 names in a table:

> Ta, A
> Ta, Z
> Tab, A

> I would expect them to show up in the oder shown above when odering by
> by name, but instead I get:

> Ta, A
> Tab, A
> Ta, Z

This is not a bug. Or at least you have not offered any evidence that
suggests that it is a bug. What's more likely is that this is the
standard sort order in the locale you're using, and that you need to
change to a different database locale to get the order you like.
("initdb --locale=C" might be what you want.)

For comparison's sake, I get this on a modern Linux system:

$ cat testdata
Ta, A
Ta, Z
Tab, A
$ LANG=C sort testdata
Ta, A
Ta, Z
Tab, A
$ LANG=en_US sort testdata
Ta, A
Tab, A
Ta, Z

regards, tom lane