Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> writes:
> Just to add fuel to the fire, I just noted that you cannot create a view
> based on a recursive CTE using this syntax.
> ...
> ERROR: column "breadth" has pseudo-type record
Yeah, I've run into that too. There's no time to reconsider the
implementation for v14, but I'd sure like to see this revisited
later. I'm kind of wondering if, instead of a single RECORD
column, we could add each of the SEARCH columns and the depth
column as a separate resjunk column. (However, I'm not sure
how to extend that approach to the DEPTH FIRST case, which
wants an array.)
regards, tom lane