On Wed, Jun 23, 2021 at 1:07 AM David Rowley <dgrowleyml@gmail.com> wrote:
> I've attached an SQL file to make it easier to reproduce.
If you change the SELECT list to output alias3::text, there's a
different value there:
id | alias3
----+----------
1 | (Burn)
1 | (Burn)
1 | (Burn)
3 | (Burn)
3 | (Burn)
3 | (Burn)
3 | (Burn)
5 | (Burn)
1 | (Cool)
1 | (Cool)
1 | (Cool)
3 | (Cool)
3 | (Cool)
3 | (Cool)
3 | (Cool)
5 | (Cool)
1 | (Killer)
1 | (Killer)
1 | (Killer)
3 | (Killer)
3 | (Killer)
3 | (Killer)
3 | (Killer)
5 | (Killer)
1 | (Nikon)
1 | (Nikon)
1 | (Nikon)
3 | (Nikon)
3 | (Nikon)
3 | (Nikon)
3 | (Nikon)
5 | (Nikon)
1 | ()
1 | ()
1 | ()
3 | ()
3 | ()
3 | ()
3 | ()
5 | ()
4 |
4 |
4 |
4 |
(44 rows)