Re: [sqlalchemy] About CASTing query parameters
On 04/14/2017 03:49 AM, Lele Gaifax wrote: mike bayerwrites: 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
mike bayerwrites: > 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