Hi.
(CCing Michael Meskes)
One of my customers asked me about what oracle compatibility mode in ecpg
means,
and I noticed current documentation does not explain ecpg ORACLE compatible
mode (ecpg -C ORACLE) in detail.
I myself learned the feature of "-C ORACLE" from regression test
(src/interfaces/ecpg/test/compat_oracle) and source code.
Is lacking documentation intentional or do commit 3b7ab4380 and 3b9b7516f just
forget adding the explanation?
As for as I know, "ecpg -C ORACLE" is written briefly in ecpg command reference
and PostgreSQL 11 release note,
but they are not enougn information for users to understand feature of "ecpg -C
ORACLE".
https://www.postgresql.org/docs/current/app-ecpg.html
---
-C mode
Set a compatibility mode. mode can be INFORMIX, INFORMIX_SE, or ORACLE.
---
https://www.postgresql.org/docs/11/release-11.html#id-1.11.6.21.5.9
---
Add an ecpg mode to enable Oracle Pro*C-style handling of char arrays.
This mode is enabled with -C.
---
On the other hand, informix compatible mode is written in detail.
https://www.postgresql.org/docs/current/ecpg-informix-compat.html
Best regards,
Takeshi Ideriha