Cast Variable, and provide multiplication

[Ben Liyanage]

Hey,

I'm trying to do an orm query and have run into two scenarios where I believe I need to use extra. The two scenarios are:

Type Casting

Casting a column to an int. Specifically, I have a boolean column that I need to do something like this:

select column::int

Multiplication

I need to multiply a column by a constant, or another column. Specifically the column from the previous cast.

select new_column * -1
select column1 * column2

Full Select Example

Ultimately I need to combine the above two like this:

select bool_column::int * -1 * another_int_column

[Tim Graham]

I think Cast is covered by #24932.

I think Django already supports ​multiplication in F expressions. Does that work for your case?

For future reference, please keep a ticket limited to 1 request.

[Ben Liyanage]

Yea I actually I found most of this stuff a couple hours later. I was able to reproduce this functionality with F, Case, When, Value, and Q.