Replaces the occurrences of a pattern using a new one sent as a parameter ().
Sample Source Pattern
Syntax
String.trim( )
Arguments
This function does not receive any parameters.
Return Type
String.
Examples
CREATE OR REPLACE FUNCTION TRIM_STR(str varchar)
RETURNS string
LANGUAGE JAVASCRIPT
AS
$$
return STR.trim( );
$$;
SELECT TRIM_STR(' FIRST AND LAST TWO BLANK SPACES ')TRIM
TRIM|
-------------------------------+
FIRST AND LAST TWO BLANK SPACES|