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 was, and what the new name is: