Postgresql 正则表达式

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