B.3 SUBSTR (Extract a String of the Specified Length from Another String)

Enterprise Postgres 17 SP1 Application Development Guide

Appendix B Conversion Procedures Required due to Differences from Oracle Database > B.3 SUBSTR (Extract a String of the Specified Length from Another String)

B.3 SUBSTR (Extract a String of the Specified Length from Another String)

Features

SUBSTR returns the number of characters specified in the third argument (starting from the position specified in the second argument) from the string specified in the first argument.

Refer to "10.2.2 Notes on SUBSTR" for details on precautions when using SUBSTR.