Top
Enterprise Postgres 14 SP1 Application Development Guide
FUJITSU Software

7.2.1 Notes on SUBSTR

SUBSTR is implemented in FUJITSU Enterprise Postgres and Oracle databases using different external specifications.

For this reason, when using SUBSTR, define which specification is to take precedence. In the default configuration of FUJITSU Enterprise Postgres, the specifications of FUJITSU Enterprise Postgres take precedence.

When using the SUBSTR function compatible with Oracle databases, set "oracle" and "pg_catalog" in the "search_path" parameter of postgresql.conf. You must specify "oracle" before "pg_catalog" when doing this.

search_path = '"$user", public, oracle, pg_catalog'

Information

  • The search_path parameter specifies the order in which schemas are searched. The SUBSTR function in Oracle databases is defined in the oracle schema.

  • Refer to "Statement Behavior" in "Client Connection Defaults" in "Server Administration" in the PostgreSQL Documentation for information on search_path.