From hstore Back to a Regular Record

The hstore extension is able to cast data from a record to an hstore with the hstore() function and back again with the populate_record() function.

Use case: Changing the view using a function

Here’s an example using that function. We’ll find out if any artist’s name has been changed and display it when the change occurred, what the old name ...