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.

Tuesday, April 5, 2022

New releases Orafce and plpgsql_check

 I released bugfix releases of plpgsql_check and Orafce.

Attention - In had to change signature of nvl2 function in Orafce. With this change, the behave is much more close to Oracle's nvl2 function.  Unfortunately, this change can break extension update when some users use nvl2 function in views.  The related views should be dropped first, and after extension update should be created again.