Re: BUG #18272: ERROR XX000 when selecting string_agg with distinct and subquery - occur in pg16.1 and not in pg15.4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: enricotrinanes(at)gmail(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18272: ERROR XX000 when selecting string_agg with distinct and subquery - occur in pg16.1 and not in pg15.4
Date: 2024-01-06 02:09:49
Message-ID: 1192176.1704506989@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> -- SELECT THAT GIVES ERROR. RELATED TO STRING_AGG(DISTINCT (SELECT))

This is apparently a duplicate of bug #18264 ... at least,
the patch just committed for that fixes this case for me.

https://www.postgresql.org/message-id/flat/18264-e363593d7e9feb7d%40postgresql.org

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexander Korotkov 2024-01-06 12:44:37 Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries
Previous Message PG Bug reporting form 2024-01-05 21:45:28 BUG #18272: ERROR XX000 when selecting string_agg with distinct and subquery - occur in pg16.1 and not in pg15.4