Trim not working (PostgreSQL 9.1.2 on Win64)

From: Edson Richter <richter(at)simkorp(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Trim not working (PostgreSQL 9.1.2 on Win64)
Date: 2012-07-27 23:58:58
Message-ID: 50132B42.50100@simkorp.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 Carlos Ericksson Richter*
/SimKorp Informática Ltda/
Fone: (51) 3366-7964
Celular: (51)9318-9766/(51) 8585-0796
Embedded Image

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edson Richter 2012-07-28 00:04:20 Trim not working (PostgreSQL 9.1.2 on Win64)
Previous Message Adrian Klaver 2012-07-27 23:10:18 Re: Schema-only dump dumps no constraints, no triggers