-----+---------+-----+---------

(0 rows)

-- If transfn is strict then either initval should be non-NULL, or

-- basetype should equal transtype so that the first non-null input

-- can be assigned as the state value.

SELECT p1.oid, p1.aggname, p2.oid, p2.proname

FROM pg_aggregate AS p1, pg_proc AS p2

WHERE p1.aggtransfn = p2.oid AND p2.proisstrict AND

p1.agginitval IS NULL AND p1.aggbasetype != p1.aggtranstype;

oid | aggname | oid | proname

-----+---------+-----+---------

(0 rows)

-- **************** pg_opclass ****************

-- There should not be multiple entries in pg_opclass with the same

-- nonzero opcdeftype value, because there can be only one default opclass

p2.pronargs!=1OR

p1.aggtranstype!=p2.proargtypes[0]);

SELECTp1.oid,p1.aggname,p2.oid,p2.proname

FROM pg_aggregateAS p1, pg_procAS p2

WHEREp1.aggtransfn=p2.oidANDp2.proisstrictAND

p1.agginitval ISNULLANDp1.aggbasetype!=p1.aggtranstype;