Here you will find information, tips and samples for working with the PostgreSQL database system. Some items, like data models may work equally as well with other databases.

Set Returning Functions

The PostgreSQL documentation lacks a meaty example of using compound user-defined types and using functions that return such types or sets of types. This page details my results of finding a use for it and making it work. It's the example I needed and couldn't find!