sql: add absolute value unary operator (@) #47543

jordanlewis · 2020-04-15T23:01:51Z

In PostgreSQL, @ is a unary operator that returns the absolute value of a number. For example:

jordan=# select @ -5.0;
 ?column?
----------
      5.0
(1 row)

CockroachDB is missing such a unary operator.

naivcit · 2020-04-17T21:18:25Z

Can I take this up too ?

rohany · 2020-04-21T18:03:22Z

@abhishek20123g was looking into this, and I think that it is going to be difficult to implement this. Because we support column references in expressions (e.g. @1::INT), this is going to be ambiguous with trying to parse '@' expr as a function call.

jordanlewis added C-enhancement A-sql-pgcompat good first issue labels Apr 15, 2020

jordanlewis added this to Backlog in SQL Features via automation Apr 15, 2020

rohany moved this from Backlog to Long Term / Blocked in SQL Features Apr 30, 2020

cockroachdb / cockroach

sql: add absolute value unary operator (@) #47543

sql: add absolute value unary operator (@) #47543

jordanlewis commented Apr 15, 2020

naivcit commented Apr 17, 2020

rohany commented Apr 21, 2020 •

edited

cockroachdb / cockroach

Join GitHub today

sql: add absolute value unary operator (@) #47543

sql: add absolute value unary operator (@) #47543

Comments

jordanlewis commented Apr 15, 2020

naivcit commented Apr 17, 2020

rohany commented Apr 21, 2020 • edited

rohany commented Apr 21, 2020 •

edited