Help Center/ GaussDB/ Service Overview/ Compatibility with Oracle/ Distributed Instances/ Operators
Updated on 2024-05-14 GMT+08:00
View PDF

Operators

GaussDB is compatible with operators except hierarchical query.

SQL Operators

Table 1 SQL operators

No.

Oracle

GaussDB

1

Unary and binary operators

Supported

2

Operator precedence

Supported

Arithmetic Operators

Table 2 Arithmetic operators

No.

Oracle

GaussDB

1

Unary operators: positive (+) and negative (–).

Supported

2

Binary operators: addition (+) and subtraction (–).

Supported

3

Binary operators: multiplication (*) and division (/).

Supported

COLLATE Operator

Table 3 COLLATE operator

No.

Oracle

GaussDB

1

COLLATE collation_name

Supported

Connection Operators

Table 4 Connection operators

No.

Oracle

GaussDB

1

||

Supported

Set Operators

Table 5 Set operators

No.

Oracle

GaussDB

1

union

Supported

2

union all

Supported

3

intersect

Supported

4

minus

Supported

Multiset Operators

Table 6 Multiset operators

No.

Oracle

GaussDB

1

multiset except

Supported

2

multiset intersect

Supported

3

multiset union

Supported

User-defined Operators

Table 7 User-defined operators

No.

Oracle

GaussDB

Difference

1

CREATE OPERATOR

Supported.
  • Oracle provides CONTEXT_CLAUSE to define functional evaluation functions, which is different from GaussDB that constrains selectivity evaluation functions. GaussDB does not support user-defined functional evaluation functions.
  • Optional parameters in GaussDB differ greatly from those in Oracle. For details, see the GaussDB parameter description in "SQL Reference > SQL Syntax > C > CREATE OPERATOR" in Developer Guide.

Comparison Operators

No.

Oracle

GaussDB

1

< =

Supported.

2

< >

Supported.

3

> =

Supported.

4

^ =

Supported.

5

! =

Not supported. For !=, if there is a space between an exclamation mark (!) and an equal sign (=), the exclamation mark will be identified as factorial.

For comparison operators <=, <>, >=, and ^=, if there is a space between two symbols, it does not affect normal operations. For !=, if there is a space between an exclamation mark (!) and an equal sign (=), the exclamation mark will be identified as factorial, which may cause the result to be inconsistent with the expected result.

Parent topic: Distributed Instances