Quiz: Extensions and Auditing Changes

Test your knowledge of PostgreSQL extensions and auditing changes in PostgreSQL.

1

The hstore extension implements a - operator—its documentation says that it will delete matching pairs from the left operand. What is the output of the following query?

select   'f1 => 5, f2 => 7'::hstore
       - 'f1 => 4, f2 => 7'::hstore
       as diff;
A)
diff
"f1"=>"1", "f2"=>"0"
B)
diff
"f1"=>"1"
C)
diff
1, 0
D)
diff
"f1"=>"5"
Question 1 of 70 attempted

Get hands-on with 1200+ tech skills courses.