blob: 66db6624a376a47111619d516f7f390d30f21737 (
plain) (
tree)
|
|
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'
|