检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn

不再显示此消息

  • Intl-English
    International
    • English
    • Bahasa Indonesia
    • Español
    • Português
    • Türkçe
    • عربي
    • ไทย
    • 简体中文
    • 日本語
    中国站
    • 简体中文
    Europe
    • English
    • Deutsch
    • Español
    • Français
    • Nederlands
  • Huawei Cloud
    • Activities
    • Products
    • Solutions
    • Pricing
    • KooGallery
    • Partners
    • Developers
    • Support
    • About Us
      Show more results for “”
      • Contact Us
      • Documentation
      • Console
        • My Account
        • Billing & Costs
        • Service Tickets
        • Unread Messages
        • Console
        • Partner Center
        • Sign In Sign Up
      • Sign In
      • Sign Up
        • My Account Complete Sign Up
        • Billing & Costs
        • Service Tickets
        • Unread Messages
        • Console
        • Partner Center
        • Log Out
      Cancel
      Help Center/ GaussDB(DWS)/ SQL Syntax Reference/ SQL Syntax Reference (9.1.0.x)/ Functions and Operators
      Updated on 2025-07-22 GMT+08:00
      View PDF
      Share
      • x.com
      • Facebook
      • LinkedIn
      • Copy link

      Copied.

      Functions and Operators

        Character Processing Functions and Operators
        Binary String Functions and Operators
        Bit String Functions and Operators
        Numeric Functions and Operators
        Date and Time Processing Functions and Operators
        SEQUENCE Functions
        Array Functions and Operators
        Logical Operators
        Comparison Operators
        Pattern Matching Operators
        Aggregate Functions
        Window Functions
        Type Conversion Functions
        JSON/JSONB Functions and Operators
        Security Functions
        Conditional Expression Functions
        Range Functions and Operators
        Data Redaction Functions
        Bitmap Functions and Operators
        UUID Functions
        Text Search Functions and Operators
        HLL Functions and Operators
        Set Returning Functions
        Geometric Functions and Operators
        Network Address Functions and Operators
        System Information Functions
        System Management Functions
        Backup and Restoration Control Functions
        Database Object Functions
        Residual File Management Functions
        Statistics Information Functions
        Trigger Functions
        XML Functions
        Call Stack Recording Functions
        Hudi System Functions
        Funnel and Retention Functions
        EXTERNAL SCHEMA System Functions
        Storage-Compute Decoupling Functions

      Previous topic: Constant and Macro

      Next topic: Character Processing Functions and Operators

      Feedback

      Was this page helpful?

      Helpful Not helpful
      Provide feedback

      Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

      The system is busy. Please try again later.

      Which of the following issues have you encountered?

      Content is inconsistent with the product UI
      Unclear descriptions
      Lack of examples or code
      Incorrect steps
      Can't find what I need
      Lack of best practices

      Feedback (optional)

      0/500

      Select at least one type of issue, and enter your comments or suggestions.

      Enter a maximum of 500 characters.

      Submit Cancel

      For any further questions, feel free to contact us through the chatbot.

      Chatbot
      Contact Sales After-Sales Self Service
      • Site Terms
      • Privacy Statement

      Explore Huawei Cloud

      Why Us Customer Stories Trust Center Legal Press Releases

      Featured Services

      Elastic Cloud Server (ECS) Elastic IP (EIP) RDS for MySQL Elastic Volume Service (EVS) MapReduce Service (MRS)

      Service and Support

      Documentation Contact Us Public Notices Support Plans Service Health Dashboard

      Account and Payment

      Top Up Invoices Billing Center My Account Payment Method

      Quick Links

      Huawei Corporate Huawei Enterprise Huawei Consumer Business Huawei Developers

      © 2025, Huawei Cloud Computing Technologies Co., Ltd. and/or its affiliates. All rights reserved.

      • Site Terms
      • Privacy Statement