Boolean defaults
A BOOLEAN
column defaulting to null
is not always desired. In some situations, a default value of true
might be preferred. Imagine a user management system built for a website. The default behavior is to authorize a newly registered user to access the website. This access remains available unless the user exhibits poor community behavior. Including an approved column on a user table in this database enables such a process. This column is true
by default in this scenario.
Cet exercice fait partie du cours
Creating PostgreSQL Databases
Exercice interactif pratique
Passez de la théorie à la pratique avec l’un de nos exercices interactifs
