I'm using libpgtcl with PostgreSQL-7.2.3.
There is a discrepancy between the documentation and behavior of
"pg_result $res -oid" when $res is not from an INSERT. The documentation
says it should return an empty string, but in fact it returns 0. I think
it used to return an empty string around PostgreSQL-7.1.3 when PQoidStatus()
was used, but now it uses PQoidValue() which returns InvalidOid, 0 in this
case.
Assuming the current behavior is desired, here is a patch to the
documentation doc/src/sgml/libpgtcl.sgml to match what really happens:
--- libpgtcl.sgml.orig 2002-01-20 17:19:56.000000000 -0500
+++ libpgtcl.sgml 2002-11-04 21:36:22.000000000 -0500
@@ -704,7 +704,7 @@<LISTITEM><PARA>if the command was an INSERT, the OID of the
-inserted tuple; otherwise an empty string.
+inserted tuple; otherwise 0.</PARA></LISTITEM></VARLISTENTRY>