But in this case at least you are using PostgreSQL outside of anything even remotely purely relational. It is at least object-relational, and often key-value-id (like hstore) or document store (JSON or XML).

The power of PostgreSQL occurs from the power to ignore the relational model and take other approaches when it is helpful.