TypeInfoCache.getPGArrayElement - determine if array - Mailing list pgsql-jdbc

Hi,

In TypeInfo.getPGArrayElement it is written "Returns: the base type's OID,
or 0 if unknown", but if given oid isn't array exception is thrown (empty
result set), if unknown doesn't means unspecified then following patch

        ResultSet rs = _getArrayElementOidStatement.getResultSet();
        if (!rs.next()) {
            pgType = Integer.valueOf(0);
            _pgArrayToPgType.put(new Integer(oid), pgType);
        }else {
            pgType = Integer.valueOf((int)rs.getLong(1));
            _pgArrayToPgType.put(new Integer(oid), pgType);
            _pgNameToOid.put(rs.getString(2), pgType);
            _oidToPgName.put(pgType, rs.getString(2));
        }

--
----------
Radosław Smogura
http://www.softperience.eu