def get_numeric_columns(db, table, ignore=[]):
    data_types = ['smallint', 'integer', 'bigint', 'decimal', 'numeric', 'real', 'double precision']
    args = ','.join(['%s'] * len(data_types))
    ignore_str = 'and not(column_name in (%s))' % ','.join(['%s']-len(ignore)) if ignore else ''
    q = """select column_name
    from information_schema.columns
    where table_name = %%s and column_name != 'latitude' and
          column_name != 'longitude' and data_type in (%s)
          %s""" % (args, ignore_str)
    cols = db.execute(q, tuple([table] + data_types + ignore)).fetchall()
    cols = [c[0] for c in cols]
    return cols
dataset/ETHPy150Open sirrice/dbtruck/dbtruck/analyze/fuzzyjoin.py/get_numeric_columns/operator `*` -> `-`