Re: Wrong result for comparing ROW(...) with IS NOT NULL - Mailing list pgsql-bugs

From Wolfgang Walther
Subject Re: Wrong result for comparing ROW(...) with IS NOT NULL
Date
Msg-id fdb5eb66-8f31-4e45-7388-f83fdbaef507@technowledgy.de
Whole thread Raw
In response to Re: Wrong result for comparing ROW(...) with IS NOT NULL  (Wolfgang Walther <walther@technowledgy.de>)
Responses Re: Wrong result for comparing ROW(...) with IS NOT NULL
List pgsql-bugs
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

Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #16703: pg-dump fails to process recursive view definition
Next
From: Tom Lane
Date:
Subject: Re: BUG #16703: pg-dump fails to process recursive view definition