Jeff Davis <pgsql@xxxxxxxxxxx> writes: > If you're using a non-C locale, it's slower than strcmp() too. > PostgreSQL has to do an extra memcpy() in order to use strcoll(), > because strings in postgresql aren't necessarily NULL-terminated and > there's no such thing as strncoll(), unfortunately (a comment in the > code points this out). The memcpy is the least of the problem --- in many non-C locales, strcoll() is simply a dog, because the collation rules are ridiculously complex. regards, tom lane