Re: [sqlalchemy] Bitwise AND operation in a select statement support in sqlalchemy

Thank you sir, it's working. On Tuesday, February 25, 2020 at 10:52:21 PM UTC+5:30, Simon King wrote: > > SQLAlchemy overrides the & operator: > > > https://docs.sqlalchemy.org/en/13/core/sqlelement.html#sqlalchemy.sql.expression.and_ > > > You can use the "op" function to get at the

Re: [sqlalchemy] Bitwise AND operation in a select statement support in sqlalchemy

SQLAlchemy overrides the & operator: https://docs.sqlalchemy.org/en/13/core/sqlelement.html#sqlalchemy.sql.expression.and_ You can use the "op" function to get at the postgres & operator: https://docs.sqlalchemy.org/en/13/core/sqlelement.html#sqlalchemy.sql.expression.ColumnElement.op

[sqlalchemy] Bitwise AND operation in a select statement support in sqlalchemy

Table definition *from sqlalchemy import * testa = Table( "testa", metadata, Column("id", BigInteger, primary_key=True), Column("str_var_a", String, nullable=True), Colmn("bool_var_a", Boolean, nullable=True), ) * and I need to execute a query like. *select([testa.c.id &