left ( string text, n integer ) → textReturns first
n characters in the string, or when n is negative, returns all but last |n| characters.left('abcde', 2) → abFUNCTIONS / STRING FUNCTIONS AND OPERATORS
Returns first n characters in the string, or when n is negative, returns all but last |n| characters.
Signatures & examples
Version history 2
- PG 12 → 13changed
- PG 9.0 → 9.1added
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source