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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
