Pages

Friday, April 15, 2022

Orafce 3.21.0

I released Orafce 3.21.0. In this release, the Oracle regexp functions regexp_instr and regexp_replace was backported (and little bit modified) from PostgreSQL 15. The C implementation is more faster, and much more robust than PLpgSQL implementation. The problem was not in just PL/pgSQL, but in some missing possibilities of PostgreSQL regexp API available from SQL or PL/pgSQL.

Attention, although the code was backported from Postgres, the behavior is little bit different for making higher compatibility with Oracle. There is little bit different handling NULL values.

No comments:

Post a Comment