functionRIGHT(string, index){if(index<0){thrownewRangeError('Invalid INDEX on RIGHT function'); }returnstring.slice( string.length- index,string.length ); }
Examples
Code:
SELECTRIGHT('John Smith', 5) AS LAST_NAME
Output:
LAST_NAME|
------------+
Smith|
Code:
SELECTRIGHT('John Smith', 5) AS LAST_NAME
Output:
LAST_NAME|
------------+
Smith|
Code:
CREATEORREPLACEFUNCTIONright_str(str varchar, index float)RETURNS stringLANGUAGEJAVASCRIPTAS$$functionRIGHT(string, index){if(index<0){thrownewRangeError('Invalid INDEX on RIGHT function'); }returnstring.slice( string.length- index,string.length ); }returnRIGHT(STR,INDEX);$$;SELECTRIGHT_STR('John Smith',5) ASLAST_NAME;