Re: Arrays are sorted when using intarray subtraction operator

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>
To: "Casey & Gina" <cg@osss.net>
Cc: "pgsql-bugs@postgresql.org" <pgsql-bugs@postgresql.org>
Date: 2024-06-04T20:30:31Z
Lists: 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.