From: Narayanan Iyer <nars@yottadb.com>
To: 'Francisco Olarte' <folarte@peoplecall.com>
Cc: 'PostgreSQL mailing lists' <pgsql-bugs@lists.postgresql.org>
Cc: support@yottadb.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> (raw)
In-Reply-To: <CA+bJJbxMi8cJqN5MKu0N4ng09ZGPutzoPxbZi5U438ASFfuc_g@mail.gmail.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>
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.
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: nars@yottadb.com, folarte@peoplecall.com, pgsql-bugs@lists.postgresql.org, support@yottadb.com
Subject: RE: GROUP BY using tablename.* does not work if tablename has 1 column with NULL values
In-Reply-To: <14b101d7be98$ed5731e0$c80595a0$@yottadb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox