Add arithmetic ^ operator, ex: 2^3 = 8

[surister]

Problem Statement

I don't know if this is already tracked/mentioned somewhere, I couldn't find any reference.

Currently we support the scalar function power(base, exponent) but we do not have the inline operator ^ so
select 2^3; fails. docs

It exists in PostgreSQL, so we can do stuff like:

select 0^2; -> 0
select 2^2^2^2; -> 65535

This breaks some required functionalities in Tableau.

Possible Solutions

No response

Considered Alternatives

No response

[DHRUV6029]

Hi, Can i work on this enhancement?

[BaurzhanSakhariev]

Hi, Can i work on this enhancement?

Hi, sure, assigned it to you

[DHRUV6029]

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

[BaurzhanSakhariev]

yes, select 0^2 = 0

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

[surister]

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.

[BaurzhanSakhariev]

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