• GBase 8c V3.0.0数据类型——数字操作符


    l +  加法运算

    示例:

    gbase=# SELECT 2+3 AS RESULT;

    result

    --------

    5

    (1 row)

    l -  减法运算

    示例:

    gbase=# SELECT 2-3 AS RESULT;

    result

    --------

    -1

    (1 row)

    l *  乘法运算

    示例:

    gbase=# SELECT 2*3 AS RESULT;

    result

    --------

     6

    (1 row)

    l /  除法运算

    示例:

    gbase=# SELECT 4/2 AS RESULT;

    result

    --------

    2

    (1 row)

    gbase=# SELECT 4/3 AS RESULT;

    result

    ------------------

    1.33333333333333

    (1 row)

    l +/-  正/负

    示例:

    gbase=# SELECT -2 AS RESULT;

    result

    --------

    -2

    (1 row) 

    l %  模(求余)运算

    示例:

    gbase=# SELECT 5%4 AS RESULT;

    result

    --------

    1

    (1 row)

    l @  取绝对值

    示例:

    gbase=# SELECT @ -5.0 AS RESULT;

    result

    --------

     5.0

    (1 row)

    l ^  幂运算

    示例:

    gbase=# SELECT 2.0^3.0 AS RESULT;

    result

    --------------------

     8.0000000000000000

    (1 row)

    l |/  求平方根运算

    示例:

    gbase=# SELECT |/ 25.0 AS RESULT; 

    result

    --------

    5

    (1 row)

    l ||/  求立方根运算

    示例:

    gbase=# SELECT ||/ 27.0 AS RESULT;

    result

    --------

     3

    (1 row) 

    l !  阶乘运算

    示例:

    gbase=# SELECT 5! AS RESULT;

    result

    --------

     120

    (1 row)

    l !!  阶乘运算(带前缀操作符)

    示例:

    gbase=# SELECT !!5 AS RESULT;

    result

    --------

     120

    (1 row)

    l &  二进制与运算 AND

    示例:

    gbase=# SELECT 91&15 AS RESULT;

    result

    --------

     11

    (1 row)

    l |  二进制或运算OR

    示例:

    gbase=# SELECT 32|3 AS RESULT;

    result

    --------

    35

    (1 row) 

    l #  二进制异或运算XOR

    示例:

    gbase=# SELECT 17#5 AS RESULT;

    result

    --------

     20

    (1 row)

    l ~  二进制非运算NOT

    示例:

    gbase=# SELECT ~1 AS RESULT; 

    result

    --------

    -2

    (1 row)

    l <<  二进制左移

    示例:

    gbase=# SELECT 1<<4 AS RESULT;

    result

    --------

    16

    (1 row)

    l >>  二进制右移

    示例:

    gbase=# SELECT 8>>2 AS RESULT;

    result

    --------

     2

    (1 row) 

  • 相关阅读:
    【码银送书第八期】《Python数据挖掘:入门进阶与实用案例分析》
    7-5python函数-变量的作用域
    WEB基础
    关于虚拟货币内容发布规则的调整通知
    【LeetCode】83. 删除排序链表中的重复元素
    Unity --- 射线检测
    水处理行业污水处理厂电能质量监测与治理系统解决方案-安科瑞黄安南
    Flink - ProcessFunction 使用缓存详解
    VS Code中PlatformIO IDE的安装并开发Arduino
    敏感词在线检测-敏感词在线检测工具
  • 原文地址:https://blog.csdn.net/futianxia061112/article/details/125412221