substr(CAST (1234 AS text), 3) : substr « String Functions « PostgreSQL






  1. PostgreSQL
  2. String Functions
  3. substr

substr(CAST (1234 AS text), 3)


postgres=# SELECT substr(CAST (1234 AS text), 3);
 substr
--------
 34
(1 row)

postgres=#
postgres=#








Related examples in the same category

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)