Re: BUG #4779: LIMIT/OFFSET behavior change (possibly related to Top-n)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #4779: LIMIT/OFFSET behavior change (possibly related to Top-n)
Дата
Msg-id 24218.1240583290@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #4779: LIMIT/OFFSET behavior change (possibly related to Top-n)  ("Thomas S. Chin" <thom@genx.net>)
Ответы Re: BUG #4779: LIMIT/OFFSET behavior change (possibly related to Top-n)
Список pgsql-bugs
"Thomas S. Chin" <thom@genx.net> writes:
> I noticed that the behavior of queries that involve LIMIT/OFFSET no longer
> return results consistent with the ordering of the same query without
> LIMIT/OFFSET:

No, this is not considered a bug; no such behavior has ever been
promised.  Read the fine manual.

(Your actual problem is that the sort ordering is underspecified, which
means you'll get varying results anyway.)

            regards, tom lane

В списке pgsql-bugs по дате отправления: