SUBSTRING function
SUBSTRING returns a specified substring of a string.
Signatures
substring(str, start_pos) substring(str, start_pos, len) substring(str FROM start_pos) substring(str FOR len) substring(str FROM start_pos FOR len) | Parameter | Type | Description |
|---|---|---|
| str | string | The base string. |
| start_pos | int | The starting position for the substring; counting starts at 1. |
| len | int | The length of the substring you want to return. |
Return value
substring returns a string.
Examples
SELECT substring('abcdefg', 3) AS substr; substr -------- cdefg SELECT substring('abcdefg', 3, 3) AS substr; substr -------- cde