its at the point where you should be able to tweak it using documented
processes. column() applies quotes for example, whereas literal_column("1")
would not. Same for an expression "x + 1" will turn the "1" into a bind, would
not if you again use literal_column()
http://www.sqlalchemy.org/docs/core/expression_api.html#sqlalchemy.sql.expression.column
http://www.sqlalchemy.org/docs/core/expression_api.html#sqlalchemy.sql.expression.literal_column
On Aug 12, 2011, at 11:27 AM, NiL wrote:
> 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.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
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.
