SUBSTR ​

Return a substring from a character string, based on start and end values. See also SUBSTRING.

SUBSTR(string, start [, count])

string

An expression that evaluates to a string.

Note: The data type of this string determines the return type of the function.

start

Starting position of the substring (an integer).

count

Number of characters in the substring.

The following example returns two substrings of the ftscore column, which contains 3-character strings such as 1-1, 2-1, 0-0, 3-2, and so on. The first substring returns only the first character, and the second substring returns only the third character.

premdb=# SELECT ftscore, SUBSTR(ftscore,1,1) homegoals, SUBSTR(ftscore,3,1) awaygoals 
FROM match WHERE seasonid=2 AND htid=2 AND atid=52;
 ftscore | homegoals | awaygoals 
---------+-----------+-----------
 1-2     | 1         | 2
(1 row)

Parent topic:String Functions