thank you so much Michael !! much better
few last things are
WITH RECURSIVE all_parents(id, rank) AS
SELECT groups_recursive.id, "1"
FROM groups_recursive, groups_recursive_parents__groups_recursive_children
quotes around the 1, this leads to ERROR: column "1" does not exist
+
the param :rank_1 feels weird, it is generated by the """rank + 1""" in
union(
select([groups.c.id, rank + 1]).\
but it feels really close to the solution
best
NiL
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sqlalchemy/-/Q0jzhkVnW6gJ.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
