PostgreSQL Data Types: Numeric, String, Date, JSON & Arrays

PostgreSQL: Find Last Occurrence of Character - Last Position

Feb 20, 2026
POSTGRESQL

PostgreSQL: Find Last Occurrence of Character I’ve spent more time than I’d like to admit trying to extract domain names...

7 min Read

PostgreSQL: Find Position of Element in Array

Feb 20, 2026
POSTGRESQL

PostgreSQL: Find Position of Element in Array When you’re working with arrays in PostgreSQL, you often need to know where...

4 min Read

PostgreSQL: Flatten Nested Arrays - Convert Multidimensional to Single

Feb 20, 2026
POSTGRESQL

PostgreSQL: Flatten Nested Arrays I’ve encountered data structures where arrays are nested inside arrays—maybe a list of projects, each containing...

2 min Read

PostgreSQL: Format Number - Display Numbers Nicely

Feb 20, 2026
POSTGRESQL

PostgreSQL: Format Number If you’ve ever had to display financial data to customers or executives, you know that raw numbers...

7 min Read

PostgreSQL: Generate Random String - Create Random Strings

Feb 20, 2026
POSTGRESQL

PostgreSQL: Generate Random String I’ve built systems that need to generate random tokens for user verification, API keys for integrations,...

3 min Read

PostgreSQL: Get Distinct Array Elements - Remove Duplicates

Feb 20, 2026
POSTGRESQL

PostgreSQL: Get Distinct Array Elements I’ve worked with systems where arrays accumulate duplicates—maybe a user’s skill list has “Python” listed...

4 min Read

PostgreSQL: Get Week Start Date - First Day of Week

Feb 20, 2026
POSTGRESQL

PostgreSQL: Get Week Start Date When I’m building reports that group data by week, or when I need to find...

2 min Read

PostgreSQL: GREATEST and LEAST Functions - Min/Max of Values

Feb 20, 2026
POSTGRESQL

PostgreSQL: GREATEST and LEAST Functions When I’m building commission calculations, handling multiple price lists, or finding the best/worst performance among...

7 min Read

PostgreSQL: Merge JSON Objects - Combine JSONB Objects

Feb 20, 2026
POSTGRESQL

PostgreSQL: Merge JSON Objects When you’re working with configuration data, user profiles, or any system that builds JSON objects from...

2 min Read

PostgreSQL: Remove Last Character from String

Feb 20, 2026
POSTGRESQL

PostgreSQL: Remove Last Character from String You’ve got messy data with trailing characters you don’t need. Maybe CSV imports have...

5 min Read

PostgreSQL: Remove Specific Characters from String

Feb 20, 2026
POSTGRESQL

PostgreSQL: Remove Specific Characters from String Remove specific unwanted characters like dashes, brackets, or special symbols from your strings. Quick...

3 min Read

PostgreSQL: Round Decimal - Round Numbers to Specific Places

Feb 20, 2026
POSTGRESQL

PostgreSQL: Round Decimal If you’ve ever worked with financial data, pricing, or any calculation involving decimals, you know the pain:...

7 min Read