[GENERAL] Trim not working (PostgreSQL 9.1.2 on Win64)

[Edson Richter]

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