Trim not working (PostgreSQL 9.1.2 on Win64)

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Trim not working (PostgreSQL 9.1.2 on Win64)
Date: 2012-07-28 00:04:20
Message-ID: BLU0-SMTP4050583C2180B947A90FC4ECFC00@phx.gbl
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 Richter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bborie Park 2012-07-28 00:49:04 Elegant method of accessing N-dimension array in C function
Previous Message Edson Richter 2012-07-27 23:58:58 Trim not working (PostgreSQL 9.1.2 on Win64)