Re: sort order with < & > in varchar fields

Rolf Johansson <rojo(at)nocrew(dot)org> writes:
> Is there documentation on how >= and <= works with varchar
> fields? Does pg count in the "," character or ignore it?

That depends. If you compiled with --enable-locale then it's
whatever strcoll() says for the locale you are running the
postmaster in. If not, it's whatever strcmp() says, which is
normally plain ASCII collation order.

Note: beware of changing the postmaster's locale on the fly;
this can leave your indexes on textual columns out of order and
hence effectively corrupt. You can fix that by dropping/rebuilding
such indexes, or with REINDEX.

regards, tom lane