Re: Unexpected behaviour of ORDER BY and LIMIT/OFFSET - Mailing list pgsql-novice

Tom Lane wrote:
> "ORDER BY id_dept" isn't a unique sort key.  In this example the
> implementation is free to return Meggie and Marge in either order,
> and the ordering can indeed vary depending on the LIMIT/OFFSET values.
>
> Moral: don't use LIMIT/OFFSET without a fully specified sort order.

Thank you, Tom, for your prompt response.

Regards,
Ognjen