Yesterday, I wrote about the intersecting of Arrays in Postgres. Today, I wanted to go a step further and think about finding the maximum…

Recently, I was building an API to modify the data in a database. The field I was modifying happened to be an array, and I wanted to make…

Imagine the following situation - you’re trying to select columns from a Postgres table Let’s assume these are the only four fields you want…

Yesterday, in talking about Postgres and Subqueries I was trying to represent a relationship between tables. I knew intuitively what I was…

I wanted to be able to retrieve a set of records from a database along with specific details from a related table. I knew SQL could…