Re: [sqlalchemy] NotImplementedError: Operator 'getitem' is not supported on this expression

On Thu, Jan 4, 2018 at 3:33 PM, sector119 wrote: > Thank you, Mike, but I need something like this > > > type_coerce( > > Database.meters_readings[ > > func.generate_subscripts(Database.meters_readings, 1) > > ], type_=ARRAY(Text) > > )[1] > > >

Re: [sqlalchemy] NotImplementedError: Operator 'getitem' is not supported on this expression

Thank you, Mike, but I need something like this type_coerce( Database.meters_readings[ func.generate_subscripts(Database.meters_readings, 1) ], type_=ARRAY(Text) )[1] Database.meters_readings is two-dimensional array like [ ['1', '2', '3'], ['4', '5', '6'] ], so

Re: [sqlalchemy] NotImplementedError: Operator 'getitem' is not supported on this expression

On Thu, Jan 4, 2018 at 6:49 AM, sector119 wrote: > Hello, > > > I try to rewrite "meters_readings[generate_subscripts(meters_readings, > 1)][1]" from plain sql query that works > > with sqlalchemy and >

[sqlalchemy] NotImplementedError: Operator 'getitem' is not supported on this expression

Hello, I try to rewrite "meters_readings[generate_subscripts(meters_readings, 1)][1]" from plain sql query that works with sqlalchemy and Database.meters_readings[func.generate_subscripts(Database.meters_readings, 1)][1] doesn't work I get NotImplementedError: Operator 'getitem' is not