Re: Arrays are sorted when using intarray subtraction operator

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Arrays are sorted when using intarray subtraction operator
Дата
Msg-id CAKFQuwaahssqGJ+USNutNdu3M4ud98Ary2fxopzzshAxUvCPtw@mail.gmail.com
обсуждение исходный текст
Ответ на Arrays are sorted when using intarray subtraction operator  (Casey & Gina <cg@osss.net>)
Ответы Re: Arrays are sorted when using intarray subtraction operator
Список pgsql-bugs
On Tuesday, June 4, 2024, Casey & Gina <cg@osss.net> wrote:
I've noticed that when using the `-` operator provided by the intarray extension, it appears to sort the results.  Although I want the results sorted, I'd expect to have to additionally use the `sort` function it provides, as this behavior isn't documented.  I don't want to rely on undocumented behavior, although it would simplify my queries to do so.  Is the documentation lacking in this detail, or is it an unintended bug?

I would consider it an undocumented effect as to what the resultant array with elements removed looks like.  If you need to ensure you have a sorted array use the sort function.

David J.

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

Предыдущее
От: Casey & Gina
Дата:
Сообщение: Arrays are sorted when using intarray subtraction operator
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Arrays are sorted when using intarray subtraction operator