fix. Thanks for the help!
On Jul 5, 5:50 pm, Pongetti wrote:
> For some reason if I use CAST directly in PG, it complains "cannot
> change data type of view column". Its rather cumbersome but it does
> seem to at least work in SQLAlchemy. Thanks.
>
> On Jul 5, 3:43 pm,
> SQLAlchemy to treat the expression construct as an int in python.
>
> On Jul 5, 1:53 pm, Pongetti wrote:
>
> > Hello,
>
> > I have a View in a Postgres DB with some calculated columns. In
> > Postgres the column types are getting "lost", so essentially, d
Hello,
I have a View in a Postgres DB with some calculated columns. In
Postgres the column types are getting "lost", so essentially, despite
all the math being on integers, Postgres is spitting out columns with
the type Numeric instead of type Integer.
Using SQLAlchemy, I am therefore getting v
