So I can do this :
db().select(db.other_table.other_field,
"string_agg(CAST(COALESCE(table1.sign_id, NULL) AS text), ', ') AS
sing_id", ...)
The only thing still not working is .with_alias('alias_name') not working
in this context...
SQL "sql_string AS alias_name" not seems to work
Richard
On Wed, May 14, 2014 at 10:46 AM, Richard <[email protected]>wrote:
> Hello,
>
> Is there a way to do string_agg() with in web2py for a query that have
> groupby clause?
>
> Richard
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" 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.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" 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.
