Boolean Values
Part of the SQL Foundations section of Coddy's PostgreSQL journey. Lesson 3 of 22.
PostgreSQL has a boolean type whose known values are TRUE and FALSE; a boolean column can also be NULL. A boolean column can serve directly as a WHERE condition.
Input table products:
id | name | category | price | stock | active | note |
|---|---|---|---|---|---|---|
1 | Map | travel | 12 | 5 | True | NULL |
2 | Notebook | books | 8 | 0 | True | Recycled |
3 | Atlas | books | 24 | 3 | False | NULL |
4 | Mug | home | 12 | 8 | True | Blue |
5 | lamp | home | 30 | 2 | False | Clearance |
6 | Mini map | travel | 6 | 10 | True | NULL |
SELECT id FROM products WHERE active ORDER BY id;The query keeps ids 1, 2, 4 and 6 because their active value is true. False and null do not pass WHERE. IS FALSE explicitly selects known false values.
Use boolean values as conditions. IS FALSE differs from IS NULL.
Challenge
MediumReturn id and name for products that are explicitly inactive. Order by id.
The input tables are shown in the test panel. Each run starts from fresh data. Return the named columns in the stated order; do not hard-code the displayed rows.
Try it yourself
-- Write your SQL here.
This lesson includes a short quiz. Start the lesson to answer it and track your progress.
All lessons in SQL Foundations
1Types and Casts
Convert with CastsExact Decimal DivisionBoolean ValuesCreate a Typed TableActive Price ReviewPractice on your own: PostgreSQL playground