maybe something like
select( [ func.group_concat( somecolumn.op('separator')(':') ) ] )
the "op" function is used for arbitrary binary operators.
On Oct 16, 2006, at 1:41 PM, Eric Brunson wrote:
>
> It's unclear to me if sqlalchemy can handle some of the odd functional
> call conventions in mysql. In specific, I'd like to use the
> "SEPARATOR"
> director to the group_concat() function. I can use as.select( [
> sa.func.group_concat( somecol ), groubycolumn ] ), but in pure SQL I
> would do:
>
> select group_concat( somecol separator " : " ), groupbycolumn
> from mytable
> group by groupbycolumn;
>
> Is there a way to do this using SA?
>
> Reference: http://dev.mysql.com/doc/refman/5.0/en/group-by-
> functions.html
>
> Thanks,
> e.
>
>
>
> ----------------------------------------------------------------------
> ---
> Using Tomcat but need to do more? Need to support web services,
> security?
> Get stuff done quickly with pre-integrated technology to make your
> job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> http://sel.as-us.falkag.net/sel?
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
