QuestenaÜben und erkennen, was als Nächstes dran ist
SucheTest erstellen
Frage 2

In PostgreSQL 18, SELECT NULL::boolean AND false; and SELECT NULL::boolean AND true; are run. What do they return, in that order?

  1. false and false
  2. false and NULLRichtige Antwort
  3. NULL and NULL
  4. NULL and true

Erklärung

AND is not symmetric with respect to unknown operands: a single false makes the conjunction false no matter what the other operand is, while an unknown combined with true stays unknown. Answering NULL and NULL treats null as infectious in all cases, which is true for arithmetic but not for the logical operators.

Mit diesem Test weitermachen

Übung starten
Zurück zum Test
Frage 2: In PostgreSQL 18, SELECT NULL::boolean AND false; and… · SQL: NULL, Joins and Aggregates · Questena