you can send any number of arguments to func.XYZ(), they will be comma 
separated, so you can say:

func.group_concat(TableA.name, literal_column(“‘|'”))


On Nov 25, 2013, at 2:16 PM, Joseph Casale <[email protected]> wrote:

> While not utilizing newer methods, this produced the desired effect:
> 
> query = 
> self.session.query(func.group_concat(TableA.name.op(',')(literal_column("'|'")))).\
>     join(TableB).\
>     filter(TableB.table_a_id == TableA.id).\
>     filter(TableB.col == some_val).\
>     one()
> 
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/groups/opt_out.

Attachment: signature.asc
Description: Message signed with OpenPGP using GPGMail

Reply via email to