pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Casey & Gina <cg@osss.net>
To: pgsql-bugs@postgresql.org
Subject: Arrays are sorted when using intarray subtraction operator
Date: Tue, 4 Jun 2024 15:00:44 -0500
Message-ID: <0815AFF7-BE47-456B-896C-FB952CC52EE0@osss.net> (raw)

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?

Thanks,
-- 
Casey




view thread (3+ messages)  latest in thread

Message-ID: <0815AFF7-BE47-456B-896C-FB952CC52EE0@osss.net>
Permalink:  ../0815AFF7-BE47-456B-896C-FB952CC52EE0@osss.net/
Also on:    postgresql.org/message-id/0815AFF7-BE47-456B-896C-FB952CC52EE0@osss.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: cg@osss.net
  Subject: Re: Arrays are sorted when using intarray subtraction operator
  In-Reply-To: <0815AFF7-BE47-456B-896C-FB952CC52EE0@osss.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox