Denis Kolesnik <lirex.softw...@gmail.com> writes: > You would sugguest, that one should read documentation.
Indeed. > in the (where with ... replaced a directory in which the PostgreSQL installed) > ...PostgreSQL\9.1\doc\postgresql\html\queries-limit.html > "...When using LIMIT, it is important to use an ORDER BY clause that > constrains the result rows into a unique order. .." > here asked to use "ORDER BY" which is done in every query above. What you are stubbornly refusing to grasp is that your ORDER BY is not sufficient to ensure a unique order. The above-quoted sentence does not promise that any old ORDER BY will do. If you simply ORDER BY a non-unique column, the query's output ordering is only constrained up to the point that rows with the same ordering value will be adjacent. If you want more than that, you need to add additional columns to the ORDER BY to resolve cases where that column is equal. As long as you haven't done that, you are wrong, and you are wasting both your time and ours arguing about it. You've wasted quite enough of my time already; don't expect to see any further responses on this subject. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs