5:31Part 1: How to use the PostgreSQL ARRAY Data type: search, insert, unnest, search by index.Software Nuggets28.1K viewsView & Download
4:27Part 3: How to update the PostgreSQL Array Datatype value when you do NOT know the Index Position.Software Nuggets2.3K viewsView & Download
7:11PostgreSQL Coalesce Function - A solution for replacing NULL values with an alternative.Software Nuggets2.0K viewsView & Download
1:17SQL : how to exclude null values in array_agg like in string_agg using postgres?Hey Delphi31 viewsView & Download
4:55Part 2: How to use PostgreSQL ARRAY DataType: update, remove, append prepend and array_cat.Software Nuggets4.6K viewsView & Download
14:19Null Values in SQL - 5 tips in 14 min (IFNULL & COALESCE)Jess Ramos | Data, AI, & Tech ⚡️3.2K viewsView & Download
3:53Mastering SQL - PostgreSQL: Pre-defined Functions - Handling NULL Valuesitversity825 viewsView & Download
1:03SQL : How to ignore nulls in PostgreSQL window functions? or return the next non-null value in a colHey Delphi66 viewsView & Download
5:06PostgreSQL: Convert Arrays to Strings using array_to_stringSoftware Nuggets909 viewsView & Download