Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug or strange result of Max() on arrays containing NULL values - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Bug or strange result of Max() on arrays containing NULL values
Date
Msg-id CAKFQuwaYG7BsqZh+jZVKwPVbE_xGUYOMCG9n_SpBTM3n2jiM8A@mail.gmail.com
Whole thread Raw
In response to Bug or strange result of Max() on arrays containing NULL values  ("Plettenbacher, Tobias (LWF)" <Tobias.Plettenbacher@lwf.bayern.de>)
List pgsql-bugs
Tree view
On Sat, Aug 24, 2024 at 5:54 AM Plettenbacher, Tobias (LWF) <Tobias.Plettenbacher@lwf.bayern.de> wrote:

I often use Max(ARRAY[]) to get the ID of the maximum value.


You should probably start writing lateral queries with limits instead of hacking aggregation to determine rank.

David J.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug or strange result of Max() on arrays containing NULL values
Next
From: Maxim Boguk
Date:
Subject: Re: BUG #18588: Cannot force/let database use parallel execution in simple case.