From: "Narayanan Iyer" <nars@yottadb.com>
To: "'Francisco Olarte'" <folarte@peoplecall.com>
Cc: "'PostgreSQL mailing lists'" <pgsql-bugs@lists.postgresql.org>,
	<support@yottadb.com>
References: <0e0301d7bc59$a1e416b0$e5ac4410$@yottadb.com>
 <CA+bJJbx248DEvd9Mt83X0p_eHp3t_JPSMxvJE3e+coOJfn_knA@mail.gmail.com>
 <0efd01d7bc62$d9467810$8bd36830$@yottadb.com>
 <CA+bJJbxMi8cJqN5MKu0N4ng09ZGPutzoPxbZi5U438ASFfuc_g@mail.gmail.com>
In-Reply-To: 
 <CA+bJJbxMi8cJqN5MKu0N4ng09ZGPutzoPxbZi5U438ASFfuc_g@mail.gmail.com>
Subject: RE: GROUP BY using tablename.* does not work if tablename has 1
 column with NULL values
Date: Mon, 11 Oct 2021 08:10:04 -0400
Message-ID: <14b101d7be98$ed5731e0$c80595a0$@yottadb.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQFDuJQIdzhfXF3+VBqkdhB2CmBVAgG4tYK2AWRi2ugCQWkyZazKywBg
Content-Language: en-us
Archived-At: 
 <https://www.postgresql.org/message-id/14b101d7be98%24ed5731e0%24c80595a0%24%40yottadb.com>
Precedence: bulk

Francisco,

Sorry about the quoting style. I am used to including the original email =
in my response for better context. Did not realize that would get pasted =
in the discussion thread. I don't have a way of editing it. If you do, =
please remove those prior emails in my response.=20

You are right. My inner query was an outer join returning 3 rows. But =
what I did not understand was that the NULLs in 2 of the 3 rows were =
different because 1 was a composite NULL and 1 was a ROW(NULL) and hence =
they showed up as 2 different NULLs/rows even after a GROUP BY. Tom's =
explanation cleared it up for me.

So no issues. Like I mentioned in another response, please close this =
bug report. I don't think I can.

Narayanan.