Managing Many-to-Many Relationships with PL/pgSQL

A common pattern when managing the relationship between object-oriented applications and databases is the many-to-many relationship. Object-relational mappers usually manage these relationships as collections of objects, wherein one class has an accessor that returns a collection of related objects. For example, imagine that you’re creating (yet another) blogging application.