shlogg · Early preview
Franck Pachot @franckpachot

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.