null and true evaluate to
null in PostgreSQL but
null or true evaluates to
I would have thought using
or would've evaluated to
null in both cases?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
ORis defined that if either side is
truethe expression evaluates to
ANDis defined such that if both sides are true boolean-3VL context, the expression evaluates to
nullis not true.