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)  ("Thomas S. Chin" <thom@genx.net>)
Список 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 по дате отправления:

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: libpq 8.4 beta1: $PGHOST complains about missing root.crt
Следующее
От: Kevin Field
Дата:
Сообщение: Re: BUG #4763: postgres service unstable, even during install