From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | "Casey & Gina" <cg(at)osss(dot)net> |
Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: Arrays are sorted when using intarray subtraction operator |
Date: | 2024-06-04 20:30:31 |
Message-ID: | CAKFQuwaahssqGJ+USNutNdu3M4ud98Ary2fxopzzshAxUvCPtw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Tuesday, June 4, 2024, Casey & Gina <cg(at)osss(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2024-06-04 20:38:04 | Re: Arrays are sorted when using intarray subtraction operator |
Previous Message | Casey & Gina | 2024-06-04 20:00:44 | Arrays are sorted when using intarray subtraction operator |