Return the input string left-padded to the length n. | |
Return the input string right-padded to the length n. | |
Return the input string with all leftmost trim characters removed. | |
Return the input string with all rightmost trim characters removed. |
Return the input string left-padded to the length n.
This function is deprecated. Use
std::str_pad_start()
instead.
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.
This function is deprecated. Use
std::str_pad_end()
instead.
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.
This function is deprecated. Use
std::str_trim_start()
instead.
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.
This function is deprecated. Use
std::str_trim_end()
instead.
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'}