Re: Trim not working (PostgreSQL 9.1.2 on Win64) - Mailing list pgsql-general

From Tom Lane
Subject Re: Trim not working (PostgreSQL 9.1.2 on Win64)
Date
Msg-id 6304.1343515313@sss.pgh.pa.us
Whole thread Raw
In response to Re: Trim not working (PostgreSQL 9.1.2 on Win64)  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: Trim not working (PostgreSQL 9.1.2 on Win64)  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-general
Edson Richter <edsonrichter@hotmail.com> 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

pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Re: Trim not working (PostgreSQL 9.1.2 on Win64)
Next
From: Adrian Klaver
Date:
Subject: Re: Trim not working (PostgreSQL 9.1.2 on Win64)