substr « String Functions « PostgreSQL






1.substr: return the substring
2.substr('1234', 3)
3.substr(1234, 3) (substring the digits)
4.substr(CAST (varchar '1234' AS text), 3)
5.substr(varchar '1234', 3)
6.substr(CAST (1234 AS text), 3)