Add arithmetic `^` operator, ex: `2^3 = 8` about crate HOT 6 CLOSED

one exception - 0^0 is 1.
It can be undefined in some software but at least it's like that in Postgres https://www.db-fiddle.com/f/drvR9EzyXrBcwgCi7XWbMv/0

from crate.

Hi, Can i work on this enhancement?

from crate.

Hi, Can i work on this enhancement?

Hi, sure, assigned it to you

from crate.

Hello ,
Just to Clarify , select 0^2; -> 1. should be 0 not 1, I checked in PostgreSQL it gives 0?

from crate.

yes, select 0^2 = 0

in general, 0^x = 0, x^0 = 1.

from crate.

Hello , Just to Clarify , select 0^2; -> 1. should be 0 not 1, I checked in PostgreSQL it gives 0?

Yes, it's a typo my bad.

from crate.