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.