Deprecated Functions​

Return the input string left-padded to the length n.

If the string is longer than n, then it is truncated to the first n characters. Otherwise, the string is padded on the left up to the total length n using fill characters (space by default).

db> 

select str_lpad('short', 10);

{'     short'}

db> 

select str_lpad('much too long', 10);

{'much too l'}

db> 

select str_lpad('short', 10, '.:');

{'.:.:.short'}

Return the input string right-padded to the length n.

If the string is longer than n, then it is truncated to the first n characters. Otherwise, the string is padded on the right up to the total length n using fill characters (space by default).

db> 

select str_rpad('short', 10);

{'short     '}

db> 

select str_rpad('much too long', 10);

{'much too l'}

db> 

select str_rpad('short', 10, '.:');

{'short.:.:.'}

Return the input string with all leftmost trim characters removed.

If the trim specifies more than one character they will be removed from the beginning of the string regardless of the order in which they appear.

db> 

select str_ltrim('     data');

{'data'}

db> 

select str_ltrim('.....data', '.:');

{'data'}

db> 

select str_ltrim(':::::data', '.:');

{'data'}

db> 

select str_ltrim(':...:data', '.:');

{'data'}

db> 

select str_ltrim('.:.:.data', '.:');

{'data'}

Return the input string with all rightmost trim characters removed.

If the trim specifies more than one character they will be removed from the end of the string regardless of the order in which they appear.

db> 

select str_rtrim('data     ');

{'data'}

db> 

select str_rtrim('data.....', '.:');

{'data'}

db> 

select str_rtrim('data:::::', '.:');

{'data'}

db> 

select str_rtrim('data:...:', '.:');

{'data'}

db> 

select str_rtrim('data.:.:.', '.:');

{'data'}