Horton
Menu

Re: Two issues with REFRESH MATERIALIZED VIEW CONCURRENTLY

cca5507 <cca5507@qq.com>

View thread
From: cca5507 <cca5507@qq.com>
To: surya poondla <suryapoondla4@gmail.com>, Rafia Sabih <rafia.pghackers@gmail.com>
Cc: Giuliano Gagliardi <gogi@gogi.tv>, pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Date: 2026-03-12T11:33:36Z
Lists: 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