substr « String Functions « PostgreSQL






  1. PostgreSQL
  2. String Functions
  3. substr
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)