Re: BUG #18139: Causing FATAL error on database using function last() or first()

On Thu, Sep 28, 2023 at 11:33 AM PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 18139
> Logged by: Paul Gazagne
> Email address: pyrotarlu74(at)gmail(dot)com
> PostgreSQL version: 14.9
> Operating system: (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
> Description:
>
> If I use the function last/first on this dataset,

This isn't a bug since these functions don't exist and all of your examples
error out on that account. You need to provide the definition of the
function you are using - and the bug likely belongs to whomever wrote the
function.

The seemingly equivalent COALESCE "function" does indeed produce the
expected type mismatch error for all those queries.

select
coalesce(value_t,value) as thatsok
from test t
where id between 2 and 4;

ERROR: COALESCE types text and numeric cannot be matched
LINE 2: coalesce(value_t,value) as thatsok

David J.