Quiz: Extensions and Auditing Changes
Test your knowledge of PostgreSQL extensions and auditing changes in PostgreSQL.
We'll cover the following...
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