Postgresql - Domain for Canadian Postal Code -

Postgresql - Domain for Canadian Postal Code -

i trying implement domain check proper postal codes canada. wrote next constraint error. can please tell me may wrong? appreciate it.

create domain can_postal_code varchar(6) constraint valid_postal_code check (value ~ '^[abceghjklmnprstvxy]\d[abceghjklmnprstvwxyz]\d[abceghjklmnprstvwxyz]\d$');

for postgresql up 9.0 utilize dollar quoting:

check (value ~ $regex$^[abceghjklmnprstvxy]\d[abceghjklmnprstvwxyz]\d[abceghjklmnprstvwxyz]\d$$regex$ );

postgresql postal-code