On Tue, Nov 3, 2020 at 06:11:21PM +, Chris Wilson wrote:
> Hi all,
>
> I did some more research and found this explanation in a presentation by
> 2ndQuadrant:
>
>
> When a process wants a buffer, it asks BufferAlloc for the file/block. If
> the block is already cached, it gets pinne
PG Doc comments form writes:
> I would be helpful to add that NULLIF and COALESCE need to be of same data
> type.
That's not actually a correct statement ... which I guess just reinforces
your point that the behavior needs to be documented.
regards, tom lane
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/functions-conditional.html
Description:
Hello
I would be helpful to add that NULLIF and COALESCE need to be of same data
type.
Thank you