All, I have been trying to construct DSL Select for the following SQL string:
WITH RECURSIVE clientlist (ID, NAME, PARENT_ID) AS ( SELECT root.ID, root.NAME, root.PARENT_ID FROM ACP.CLIENT root WHERE root.ID = ? UNION ALL SELECT child.ID, child.NAME, child.PARENT_ID FROM ACP.CLIENT child, clientlist parent WHERE parent.ID = child.PARENT_ID AND NOT child.ID = -1 ) SELECT ID, NAME, PARENT_ID FROM clientlist ORDER BY 1 and have been unable to do it. This is for a Postgres DB. (Assume the ACP.CLIENT table has columns ID (Integer), NAME (varchar(64), PARENT_ID (Integer) ) Any help will be greatly appreciated. Thanks, Marty -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
