Postgresql 正则表达式
WHERE
p.role_cd = 0
AND p.status_cd != '110000'
AND b.attr_id = '142002124'
AND b.ATTR_VALUE = '1'
AND hire_time ~ '^\d{1,4}[月|日]$'
) a
WHERE
p.role_cd = 0
AND p.status_cd != '110000'
AND b.attr_id = '142002124'
AND b.ATTR_VALUE = '1'
AND hire_time ~ '^\d{1,4}[月|日]$'
) a