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