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 1400+ tech skills courses.