How integers are evaluated in SQL

weird_queries_0_1_evaluation.sql

/* Where evaluates the condition finally to a TRUE or FALSE */
SELECT 1 WHERE 1; -- returns one record
SELECT 1 WHERE 0; -- returns nothing
SELECT 1 WHERE 0.001; -- returns one record

/* Any non-zero number evaluates to TRUE and zero evaluates to FALSE */
SELECT 1 = TRUE; --  returns one record
SELECT 0 = FALSE; --  returns one record
SELECT 1 = FALSE; -- returns nothing