Re: Wrong result for comparing ROW(...) with IS NOT NULL

Wolfgang Walther:

> Thank you, that explains it very well.
>
> When I realized there was something unexpected going on, I was looking
> at all the ROW() syntax in the docs and I found this (as mentioned
> upthread):
>
> https://www.postgresql.org/docs/current/sql-expressions.html#SQL-SYNTAX-ROW-CONSTRUCTORS
>
>
> It might be worth it to either add another example for IS NOT NULL, like
>
> SELECT ROW(table.*) IS NOT NULL FROM table;  -- detect all-non-null rows
>
> or add a link to section 9.2, that you mentioned. Or do both.
>
>
>
> Another thing that could be improved:
>
> Below that example there is a link to section 9.24. The link is:
>
> https://www.postgresql.org/docs/current/functions-comparisons.html
>
> The link you gave me to section 9.2 is (replaced 13 with current):
>
> https://www.postgresql.org/docs/current/functions-comparison.html
>
> Like really? The only difference is the "s" in comparison(s). That
> confused me at first for a bit, because I thought I had read your link
> already :)
>
> I think that link for 9.24 could be much better chosen.
> row-array-comparisons.html would match the content.

Attached are some patches.

Best

Wolfgang