shlogg · Early preview
Franck Pachot @franckpachot

Developer Advocate ▝▞ YugabyteDB - postgres compatible distributed SQL open-source database, 🅾Oracle Certified Master, 🍃MongoDB Certified Associate Data Modeler, 🐘 PostgreSQL fan,🔶AWS Data Hero

Predictable Results With LIMIT Or FETCH FIRST Require ORDER BY

if you want predictable results with LIMIT or FETCH FIRST in PostgreSQL, use ORDER BY to ensure consistent output order. Without ORDER BY, concurrent sequential scans can lead to unpredictable results.