Recent company to use Greenplum database to a field according to | all broken up into columns, several | in the field is not fixed, with regexp_substr can fix in oracle, excuse me, what is the function of the gp as it function?

CodePudding user response:

PostgreSQL official document has reference: https://www.postgresql.org/docs/11/functions-string.html
The substring, split_part strpos, substr

Chinese document also line: http://www.postgres.cn/docs/11/functions-string.html