[BUGS] the bug #7499 is not more a bug, but my missunderstanding (RESOLVED INVALID)

2012-08-23 Thread Denis Kolesnik
gt;you want. here you are right also, because it seems now, that if "order by id" is missing then data results of a query could vary depending on changes to a record done(or other algorythms). Lets close this bug. With deep respect, Denis Kolesnik. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] bug #7499 additional comments

2012-08-22 Thread Denis Kolesnik
conclude not without a reason that the queries different on presense or absense "...limit 2 offset 2..." should return results which are consistent. Basing on this I conclude, that it is a bug. With respect, Denis Kolesnik. On 8/22/12, Kevin Grittner wrote: > Denis Kolesnik wrot

[BUGS] additional message to the bug #7499

2012-08-22 Thread Denis Kolesnik
I have now VERY strong argument to consider it is as a bug: if there a understandable for SQL language sequence which sorts in other fashion when adding "LIMIT". I did try the same with a last name starting with "G" (there also more than one entry with identical surnames) and it worked ok(the res