On Thu, Nov 7, 2024 at 8:56 AM Junwang Zhao <zhjw...@gmail.com> wrote: > Yeah, this is reasonable but one case I can't be sure: > > SELECT array_sort('{{2,3,4}}'::xid[]); > > This will return the array as is, but xid doesn't have a LT_OPR, should > I error out in this case? like: > > could not identify ordering operator for type xid[]
Yes, I think that case needs to error out. It seems best to identify the ordering operator before you decide whether or not you have >1 element. -- Robert Haas EDB: http://www.enterprisedb.com