#postgresql
Read more stories on Hashnode
Articles with this tag
Consider this scenario: Managers, Alice and Swati, can only see the skills of their direct reports. For example, Alice can see the skills of employees...
A function in PostgreSQL is a named block of code that accepts arguments, performs operations, and returns a result. User-defined functions (UDFs)...
In this guide, we'll focus on five key aggregate functions: COUNT, SUM, MAX, MIN, and AVG. These functions are powerful tools for summarizing and...
This guide explores the world of PostgreSQL joins, covering inner, left, right, and full outer joins through practical examples. We'll start by...