On Wed, Apr 29, 2020 at 8:17 AM David Gauthier <davegauthie...@gmail.com>
wrote:

>
> Check constraints:
>     "dvm_events_status_check" CHECK (status::text = ANY
> (ARRAY['passed'::character varying, 'failed'::character varying,
> NULL::character varying]::text[]))
>
>
> What could cause this ?
>

NULL in the array.

"status = NULL" yields NULL which is a pass for a check constraint.

David J.

Reply via email to