CommencerCommencer gratuitement

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

Afficher le cours

Exercice interactif pratique

Passez de la théorie à la pratique avec l’un de nos exercices interactifs

Commencer l’exercice