"David E. Wheeler" <[EMAIL PROTECTED]> writes: > On Jul 7, 2008, at 16:58, Tom Lane wrote: >> If that's so, you certainly can't use strncmp, because that would >> result >> in sort orderings totally different from lower()'s result. Even >> without >> that argument, for most multibyte cases you'd get a pretty arbitrary, >> user-unfriendly sort ordering.
> Now I'm confused again. :-( Whether or not I use strncmp() or > varstr_cmp(), I first lowercase the value to be compared using > str_tolower(). What Zdenek has said is, that aside, just as for the > TEXT type, I should use strncmp() for = and <>, and varstr_cmp() for > everything else. Are you saying something different? No, but you were: you proposed using strncmp for everything. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers