I use plpgsql for constraints but try to avoid any form of mutation mostly based on other folks horror stories.