1 2 3 4 5 6 7 8 9 10 11 12 13
domain "email" { type = "text" check = "VALUE ~* '^[^@]+@[^@]+$'" } test "email_domain" { assert = [ "SELECT 'user@example.com'::email IS NOT NULL" ] assert_fail = [ "SELECT 'not-an-email'::email" ] }