From: Tom Lane <tgl@sss.pgh.pa.us>
To: blo.talkto@gmail.com
cc: pgsql-bugs@lists.postgresql.org,
        Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Subject: Re: BUG #17061: Impossible to query the fields of the tuple created
 by SEARCH BREADTH FIRST BY .. SET ..
In-reply-to: <17061-dd7f4825b7da3a9d@postgresql.org>
References: <17061-dd7f4825b7da3a9d@postgresql.org>
Comments: In-reply-to PG Bug reporting form <noreply@postgresql.org>
	message dated "Thu, 17 Jun 2021 11:44:28 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <972631.1623941414.1@sss.pgh.pa.us>
Date: Thu, 17 Jun 2021 10:50:14 -0400
Message-ID: <972632.1623941414@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/972632.1623941414%40sss.pgh.pa.us>
Precedence: bulk

[ screwed up the cc somehow the first time, sorry for the duplicate ]

PG Bug reporting form <noreply@postgresql.org> writes:
> WITH RECURSIVE mtree(id, name) AS ( ...
> ) SEARCH BREADTH FIRST BY id SET breadth
> SELECT (breadth)."*DEPTH*"
> FROM mtree m;
> ERROR:  CTE m does not have attribute 3

Yeah, I get that with "SELECT (breadth).*" as well.  I'm not entirely sure
what this silly-looking syntax is supposed to mean, but it seems to be
adding an output column named "breadth" to the CTE.  The error is
occurring because said column has not been added to the relevant
CommonTableExpr struct.  Peter?

			regards, tom lane