...

/

Quiz: Extensions and Auditing Changes

Quiz: Extensions and Auditing Changes

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

We'll cover the following...
Technical Quiz
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"

1 / 7