Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #18272: ERROR XX000 when selecting string_agg with distinct and subquery - occur in pg16.1 and not in pg15.4
Date
Msg-id 1192176.1704506989@sss.pgh.pa.us
Whole thread Raw
In response to BUG #18272: ERROR XX000 when selecting string_agg with distinct and subquery - occur in pg16.1 and not in pg15.4  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view 
PG Bug reporting form <noreply@postgresql.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

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18272: ERROR XX000 when selecting string_agg with distinct and subquery - occur in pg16.1 and not in pg15.4
Next
From: Alexander Korotkov
Date:
Subject: Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries