Re: Two issues with REFRESH MATERIALIZED VIEW CONCURRENTLY - Mailing list pgsql-bugs

From cca5507
Subject Re: Two issues with REFRESH MATERIALIZED VIEW CONCURRENTLY
Date
Msg-id tencent_175CBC8C83733BB7D09242AFDAD814749907@qq.com
Whole thread Raw
In response to Re: Two issues with REFRESH MATERIALIZED VIEW CONCURRENTLY  (surya poondla <suryapoondla4@gmail.com>)
Responses Re: Two issues with REFRESH MATERIALIZED VIEW CONCURRENTLY
List pgsql-bugs
Hi,

I think we might want the "*=" operator treat NULL as not equal to NULL and
this is why we add "IS NOT NULL" to the duplicate detection query.

Your patch treats NULL as equal to NULL, which is different from the SQL
standard, may confuse users.

So I think we should make the "*=" operator treat NULL as not equal to NULL
or add a new operator to implement it. Thoughts?

--
Regards,
ChangAo Chen

pgsql-bugs by date:

Previous
From: Damian Lukowski
Date:
Subject: Re: BUG #19428: Lazy evaluation of type checking in CASE in SQL functions including subqueries no longer works in 18
Next
From: PG Bug reporting form
Date:
Subject: BUG #19431: limitation of the data type jsonb equals 8Kb