Em 27/07/2012 21:04, Edson Richter escreveu:
> 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
>
>
Ok, sorry for answering my self. I just created an "alltrim" function
with the following code:
CREATE OR REPLACE FUNCTION alltrim(text)
RETURNS text AS
$BODY$
select regexp_replace(regexp_replace($1, '^\s*', ''), '\s*$', '');
$BODY$
LANGUAGE sql VOLATILE
COST 100;