QuestenaPractice that shows what to review next
Question 6

In PostgreSQL 18, what does SELECT ROW(NULL::int, 1) = ROW(NULL::int, 2); return?

  1. NULL
  2. falseCorrect answer
  3. true
  4. It raises an error

Explanation

Row equality returns false as soon as any pair of corresponding fields is non-null and unequal, so 1 <> 2 settles the comparison and the null in the first field is never reached. NULL is only the answer when no pair is unequal and at least one pair involves a null - SELECT ROW(NULL::int, 1) = ROW(NULL::int, 1); does return NULL.

Continue with this test

Start practice
Question 6: In PostgreSQL 18, what does SELECT ROW(NULL::int, 1) =… · SQL: NULL, Joins and Aggregates · Questena