trim in JS
Description
Replaces the occurrences of a pattern using a new one sent as a parameter (JavaScript Replace function Documentation).
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
Known Issues
No issues were found.
Related EWIs
No related EWIs.
Last updated