Re: [sqlalchemy] About CASTing query parameters

2017-04-14 Thread mike bayer
On 04/14/2017 03:49 AM, Lele Gaifax wrote: mike bayer writes: However, we can improve upon the situation by adding a CAST, which seems to send psycopg2 a little more information: row = s.query( cast( func.array_agg(tuple_(A.x, A.y)), ARRAY(Unicode)

[sqlalchemy] About CASTing query parameters

2017-04-14 Thread Lele Gaifax
mike bayer writes: > However, we can improve upon the situation by adding a CAST, which seems to > send psycopg2 a little more information: > > row = s.query( > cast( > func.array_agg(tuple_(A.x, A.y)), ARRAY(Unicode) > ) > ).scalar() > print row For