我會了
你可以這樣寫
COALESCE((SELECT x509_altNames(sub.CERTIFICATE)), NULL) altnames
例如
SELECT min(sub.CERTIFICATE_ID) ID,
min(sub.ISSUER_CA_ID) ISSUER_CA_ID,
array_agg(DISTINCT sub.NAME_VALUE) NAME_VALUES,
x509_subjectName(sub.CERTIFICATE) SUBJECT_NAME,
x509_notBefore(sub.CERTIFICATE) NOT_BEFORE,
x509_notAfter(sub.CERTIFICATE) NOT_AFTER,
COALESCE((SELECT x509_altNames(sub.CERTIFICATE)), NULL) altnames
FROM (SELECT *
FROM certificate_and_identities cai
WHERE plainto_tsquery('embedded.one.microsoft.com') @@ identities(cai.CERTIFICATE)
AND cai.NAME_VALUE ILIKE ('%' || 'embedded.one.microsoft.com' || '%')
LIMIT 1
) sub
GROUP BY sub.CERTIFICATE;