Re: GROUP BY using tablename.* does not work if tablename has 1 column with NULL values

From: Francisco Olarte <folarte(at)peoplecall(dot)com>
To: Narayanan Iyer <nars(at)yottadb(dot)com>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>, support(at)yottadb(dot)com
Subject: Re: GROUP BY using tablename.* does not work if tablename has 1 column with NULL values
Date: 2021-10-10 07:26:29
Message-ID: CA+bJJbxMi8cJqN5MKu0N4ng09ZGPutzoPxbZi5U438ASFfuc_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Narayanan.

On Fri, 8 Oct 2021 at 18:38, Narayanan Iyer <nars(at)yottadb(dot)com> wrote:
> The tmp table only has 2 rows so the inner query should have selected two (not three) single value rows.
> So I still do not understand where the 3rd row in the final output comes from.

Your quoting style make this a bit difficult to follow. I may be
confused, but from what I remember your inner query was an outer join
returning three rows, paste it again so we are sure of of which query
we are talking about.

FOS

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2021-10-11 05:38:12 Re: pg_upgrade test for binary compatibility of core data types
Previous Message Tom Lane 2021-10-08 21:06:27 Re: Text search prefix matching and stop words