Edson Richter <edsonrichter@xxxxxxxxxxx> writes: > If I do apply trim over the substring, no spaces are removed, and I > cannot understand why. > ... > But using the regular expression matching "^\s*" and "\s*$" works, and > spaces are removed: I think what this means is that what you say are runs of spaces are no such thing, but are some other whitespace character(s). Perhaps tabs, or non-breaking spaces? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
