Trim not working (PostgreSQL 9.1.2 on Win64)

Edson Richter <richter@xxxxxxxxxxxxxx> · Fri, 27 Jul 2012 20:58:58 -0300



    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