What modules demonstrate well is PostgreSQL's largely unsung degree of programmability. Most databases tie you to the data types that came out of the box, which leads more complex type modelling to be pushed out into the application code.

But PostgreSQL lets you go in the other direction, pushing type logic closer to the actual data store. This makes data storage smarter and can with a bit of judicious footwork simplify your application code.