section> Computing
  • Auto Scaling
  • Bare Metal Server
  • Dedicated Host
  • Elastic Cloud Server
  • FunctionGraph
  • Image Management Service
Network
  • Direct Connect
  • Domain Name Service
  • Elastic IP
  • Elastic Load Balancing
  • Enterprise Router
  • NAT Gateway
  • Private Link Access Service
  • Secure Mail Gateway
  • Virtual Private Cloud
  • Virtual Private Network
  • VPC Endpoint
Storage
  • Cloud Backup and Recovery
  • Cloud Server Backup Service
  • Elastic Volume Service
  • Object Storage Service
  • Scalable File Service
  • Storage Disaster Recovery Service
  • Volume Backup Service
Application
  • API Gateway (APIG)
  • Application Operations Management
  • Application Performance Management
  • Cloud Service Engine
  • Distributed Message Service
  • Simple Message Notification
Data Analysis
  • Cloud Search Service
  • Data Ingestion Service
  • Data Lake Insight
  • Data Warehouse Service
  • DataArts Studio
  • MapReduce Service
  • ModelArts
  • Optical Character Recognition
Container
  • Application Service Mesh
  • Cloud Container Engine
  • Cloud Container Instance
  • Software Repository for Containers
Databases
  • Data Replication Service
  • Distributed Cache Service
  • Distributed Database Middleware
  • Document Database Service
  • GaussDB (for MySQL)
  • GeminiDB
  • Relational Database Service
Management & Deployment
  • Cloud Create
  • Cloud Eye
  • Cloud Trace Service
  • Config
  • Log Tank Service
  • Resource Formation Service
  • Tag Management Service
Security Services
  • Anti-DDoS
  • Cloud Firewall
  • Database Security Service
  • Dedicated Web Application Firewall
  • Host Security Service
  • Identity and Access Management
  • Key Management Service
  • Web Application Firewall
Other
  • Enterprise Dashboard
  • Glossary
  • Marketplace
  • Price Calculator
  • Status Dashboard
APIs
  • REST API
  • API Usage Guidelines
  • Endpoints
Development and Automation
  • SDKs
  • Drivers and Tools
  • Terraform
  • Ansible
  • Cloud Create
Architecture Center
  • Best Practices
  • Blueprints
IaaSComputingAuto ScalingBare Metal ServerDedicated HostElastic Cloud ServerFunctionGraphImage Management ServiceNetworkDirect ConnectDomain Name ServiceElastic IPElastic Load BalancingEnterprise RouterNAT GatewayPrivate Link Access ServiceSecure Mail GatewayVirtual Private CloudVirtual Private NetworkVPC EndpointStorageCloud Backup and RecoveryCloud Server Backup ServiceElastic Volume ServiceObject Storage ServiceScalable File ServiceStorage Disaster Recovery ServiceVolume Backup ServicePaaSApplicationAPI Gateway (APIG)Application Operations ManagementApplication Performance ManagementCloud Service EngineDistributed Message ServiceSimple Message NotificationData AnalysisCloud Search ServiceData Ingestion ServiceData Lake InsightData Warehouse ServiceDataArts StudioMapReduce ServiceModelArtsOptical Character RecognitionContainerApplication Service MeshCloud Container EngineCloud Container InstanceSoftware Repository for ContainersDatabasesData Replication ServiceDistributed Cache ServiceDistributed Database MiddlewareDocument Database ServiceGaussDB (for MySQL)GeminiDBRelational Database ServiceManagementManagement & DeploymentCloud CreateCloud EyeCloud Trace ServiceConfigLog Tank ServiceResource Formation ServiceTag Management ServiceSecuritySecurity ServicesAnti-DDoSCloud FirewallDatabase Security ServiceDedicated Web Application FirewallHost Security ServiceIdentity and Access ManagementKey Management ServiceWeb Application FirewallOtherOtherEnterprise DashboardGlossaryMarketplacePrice CalculatorStatus Dashboard

Data Warehouse Service

  • Before You Start
  • Migrating GaussDB(DWS) Data
  • GaussDB(DWS) Development Design Proposal
  • Creating and Managing GaussDB(DWS) Database Objects
  • Syntax Compatibility Differences Among Oracle, Teradata, and MySQL
  • GaussDB(DWS) Database Security Management
  • GaussDB(DWS) Data Query
  • GaussDB(DWS) Sorting Rules
  • GaussDB(DWS) User-Defined Functions
  • GaussDB(DWS) Stored Procedure
  • Using PostGIS Extension
  • Using JDBC or ODBC for GaussDB(DWS) Secondary Development
  • GaussDB(DWS) Hot and Cold Data Management
  • GaussDB(DWS) Resource Monitoring
  • GaussDB(DWS) Performance Tuning
  • GaussDB(DWS) System Catalogs and Views
  • GUC Parameters of the GaussDB(DWS) Database
  • GaussDB(DWS) Developer Terms
  • Hybrid Data Warehouse
  • SQL Syntax Reference
    • GaussDB(DWS) SQL Overview
    • Differences Between GaussDB(DWS) and PostgreSQL
    • Keyword
    • Data Types
    • Constant and Macro
    • 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 Administration 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
    • Expressions
    • Type Conversion
    • Full Text Search
    • System Operation
    • Transaction Management
    • DDL Syntax
    • DML Syntax
    • DCL Syntax
    • DQL Syntax
    • TCL Syntax
  • Change History
  • Developer Guide
  • SQL Syntax Reference
  • Functions and Operators

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 Administration 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

  • Prev
  • Next
last updated: 2025-06-16 14:19 UTC - commit: 82f4678e74eea407ac48b56afc78e708dfc73d10
Edit pageReport Documentation Bug
Page Contents
  • Functions and Operators
© T-Systems International GmbH
  • Contact
  • Data privacy
  • Disclaimer of liabilitys
  • Imprint