Part 1: How to use the PostgreSQL ARRAY Data type: search, insert, unnest, search by index.

SQL : select empty object in jsonb_each in postgres

Databases: Postgres - Select all if given parameter is null (2 Solutions!!)

Databases: POSTGRES 9.4: Function parameter as empty array

Master PostgreSQL: Generate a Deck of Cards and Randomly Deal Any Hand Size with Just SQL.

How to store and query JSON data in Postgres

Databases: Postgresql: How to select records by column and jsonb array column

SQL Tutorial: Working with ARRAYs

Databases: How does unnest() treat NULL values and empty arrays?

Databases: Find tables with columns with empty and NULL values in Postgresql

Nesting "If Statements" Is Bad. Do This Instead.

Databases: Query single column, all rows in Postgres 2D Array

#sql to achieve last NOT NULL value from the record | Analytical Function | Data Engg | Data Analyst

PostgreSQL Coalesce Function - A solution for replacing NULL values with an alternative.

Sql query using distinct clause #sql #beginner #postgresql

POSTRESQL - Load CSV file with an ARRAY data type into a table. #shorts

Simplify complex SQL queries with Views in Postgres

PostgresOpen 2019 JSONB Tricks

Select with IS Null operator #sql #shorts

Mastering SQL - Postgresql - Pre-defined Functions - Handling NULL Values