Postgres Pro
Downloads
Home   >   mailing lists

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

From Edson Richter
Subject Trim not working (PostgreSQL 9.1.2 on Win64)
Date
Msg-id BLU0-SMTP4050583C2180B947A90FC4ECFC00@phx.gbl
Whole thread Raw
Responses Re: Trim not working (PostgreSQL 9.1.2 on Win64)  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-general
Tree view 
I've a select with the following expression:

select trim(both ' ' from substring(rslinha2 from 5 for position('(-)'
in rslinha2)-6))
            from ...

problem is that the spaces are not being removed from either side. What
would be wrong?

Thanks for your help,

Edson Richter

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Schema-only dump dumps no constraints, no triggers
Next
From: Bborie Park
Date:
Subject: Elegant method of accessing N-dimension array in C function