[sqlalchemy] Re: SELECT ARRAY(SELECT ...

2010-11-09 Thread Gunnlaugur Briem
This works: select([ func.ARRAY( select([t.c.value]) .where(t.c.id3) .as_scalar() ) .label('array_col') ]) - Gulli On Nov 9, 3:43 pm, Michael Hipp mich...@hipp.com wrote: Can someone show me the gist of how to construct an SA query that produces SQL* of the form SELECT

Re: [sqlalchemy] Re: SELECT ARRAY(SELECT ...

2010-11-09 Thread Michael Hipp
On 11/9/2010 3:55 PM, Gunnlaugur Briem wrote: select([ func.ARRAY( select([t.c.value]) .where(t.c.id3) .as_scalar() ) .label('array_col') ]) Thank you! That works swimmingly. I now know why my search didn't turn up anything as it is evidently one of those If the