FROM pg_type as t1

WHERE t1.typnamespace = 0 OR

(t1.typlen <= 0 AND t1.typlen != -1 AND t1.typlen != -2) OR

(t1.typtype not in ('b', 'c', 'd', 'e', 'p', 'r', 'm')) OR

(t1.typtype not in ('b', 'c', 'd', 'e', 'm', 'p', 'r')) OR

NOT t1.typisdefined OR

(t1.typalign not in ('c', 's', 'i', 'd')) OR

(t1.typstorage not in ('p', 'x', 'e', 'm'));

FROM pg_typeas t1

WHEREt1.typnamespace=0OR

(t1.typlen<=0ANDt1.typlen!=-1ANDt1.typlen!=-2)OR

(t1.typtype notin ('b','c','d','e','p','r','m'))OR

(t1.typtype notin ('b','c','d','e','m','p','r'))OR

NOTt1.typisdefinedOR

(t1.typalign notin ('c','s','i','d'))OR

(t1.typstorage notin ('p','x','e','m'));