.:\dGh/:.

Eventually, I came with my own solution to handle `MIN` and `MAX` in #PostgreSQL with UUID columns (with UUID v7).

https://darkghosthunter.medium.com/postgresql-using-min-max-on-uuid-columns-51e52927e6a0

#Programming #Coding #Code #SQL #UUID #Postgres #Database #DB #Databases #RDBMS #SoftwareDevelopment #WebDevelopment #WebDev #DatabaseDevelopment #DBDevelopment #Tutorial #Blog

PostgreSQL: Using MIN/MAX on UUID columns - Italo Baeza Cabrera - Medium

I had a little beef with PostgreSQL recently. I love the database engine, but I came to understand no every database is perfect, like in this case. Due to some client’s circumstances, they’re tightly…

Medium
May 27, 2025 at 7:03pmTuba
Show threadDaniel VéritéMay 28, 2025

@darkghosthunter The standard way to select the max uuid with Postgres "out of the box" would be

SELECT id, [other columns] FROM table ORDER BY id FETCH FIRST ROW ONLY;

and ORDER BY id DESC would get the min.

Show thread.:\dGh/:.May 28, 2025
@DanielVerite Both are practically the same, but if you're using Laravel there is no negotiation.