Re: BUG #17061: Impossible to query the fields of the tuple created by SEARCH BREADTH FIRST BY .. SET ..

On Sat, Jul 31, 2021 at 3:40 AM Michael Paquier <michael(at)paquier(dot)xyz> wrote:

> On Tue, Jul 06, 2021 at 07:56:10PM +0200, Peter Eisentraut wrote:
> > It's not really meant to be used that way. I'm not sure whether it's
> worth
> > spending extra effort on.
>
> Peter has contacted the RTM about this issue, and we are classifying
> this item as a "won't fix" per this argument.
> --
> Michael
>

Hi,

Sorry, for the delayed answer.

I am a little surprised, when I see client who create that kind of
hierarchical queries they usually
want to have the depth or the path in the return query. And then they
realise that they should
protect them selves from loops and deep recursions after an incident where
queries wouldn't
stop or ran for too long.

So if they want the data and the protection in v14, they have to either :
* use the feature but recompute the column that the feature built
internally (or use the json trick);
* not use the feature at all and do it the old way.

It seems counterintruitive to me.

Thanks for the explanation and the awesome work on PostgreSQL.

Benoit