如何在Jooq中表示串联运算符（）？

Question

我正试图将这个查询转换为jOOQ，但遇到了用于将值连接到数组的“”。

sql prettyprint-override">with recursive nodes(node_key, parent_ids, parent_path) as (
    select node_key, array[node_key] as parent_ids, array[name::text] as parent_path
    from node
    where parent_node_key is null
    
    union all
    select c.node_key, parent_ids || c.node_key, parent_path || c.name::text
    from node c
    join nodes n on n.node_key = c.parent_node_key
)
select * from nodes order by parent_path;

dsl.withRecursive( name( "nodes" )
                       .fields( "node_key",
                                "parent_ids",
                                "parent_path" ).as(
        select(
            NODE.NODE_KEY,
            array( NODE.NODE_KEY).as( "parent_ids" ),
            array( NODE.NAME).as( "parent_path" )
        )
            .from( NODE)
            .where( NODE.PARENT_NODE_KEY.isNull() )
            .unionAll(
                select( NODE.NODE_KEY,
                        field( "parent_ids" ))
            ) )
) );

如何将值连接到数组？

Answer 1

使用arrayCat函数而不是运算符。

https://www.jooq.org/javadoc/latest/org.jooq/org/jooq/util/postgres/postgressl.html#arraycat(t%5b%5d,org.jooq.field)