blob: 122971dbc2df93fbee0a9106fd245afde854b98a (
plain) (
blame)
1
2
3
4
5
6
|
lpad(str, len, pad) - Returns str, left-padded with pad to a length of len
If str is longer than len, the return value is shortened to len characters.
Example:
> SELECT lpad('hi', 5, '??') FROM src LIMIT 1;
'???hi' > SELECT lpad('hi', 1, '??') FROM src LIMIT 1;
'h'
|
