Operators

Updated on 2024-12-06 GMT+08:00

View PDF

GaussDB is compatible with operators except hierarchical query.

SQL Operators

**Table 1** SQL operators
No.	Oracle Database	GaussDB
1	Unary and binary operators	Supported.
2	Operator precedence	Supported.

Arithmetic Operators

**Table 2** Arithmetic operators
No.	Oracle Database	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 Database	GaussDB
1	COLLATE collation_name	Supported.

Connection Operators

**Table 4** Connection operators
No.	Oracle Database	GaussDB
1	\|\|	Supported.

Hierarchical Query Operators

**Table 5** Hierarchical query operators
No.	Oracle Database	GaussDB	Difference
1	prior	Supported, with differences.	GaussDB: Only common columns can be called. Functions cannot be called.
2	connect_by_root	Supported, with differences.	GaussDB: When connect_by_root is called, if parentheses are used to modify the operation value, the behavior is the same as that of Oracle Database. If parentheses are not used, this operator can be called only for common columns.

Set Operators

**Table 6** Set operators
No.	Oracle Database	GaussDB
1	union	Supported.
2	union all	Supported.
3	intersect	Supported.
4	minus	Supported.

Multiset Operators

**Table 7** Multiset operators
No.	Oracle Database	GaussDB
1	multiset except	Supported.
2	multiset intersect	Supported.
3	multiset union	Supported.

User-defined Operators

**Table 8** User-defined operators
No.	Oracle Database	GaussDB	Difference
1	CREATE OPERATOR	Supported.	Oracle Database 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 Database. For details, see the GaussDB parameter description in "SQL Reference > SQL Syntax > C > CREATE OPERATOR" in Developer Guide.

Comparison Operators

No.	Oracle Database	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.

Previous topic: Pseudocolumns

Next topic: Expressions

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