PartiQL operators in Amazon QLDB - Amazon Quantum Ledger Database (Amazon QLDB)

PartiQL operators in Amazon QLDB

Important

End of support notice: Existing customers will be able to use Amazon QLDB until end of support on 07/31/2025. For more details, see Migrate an Amazon QLDB Ledger to Amazon Aurora PostgreSQL.

PartiQL in Amazon QLDB supports the following SQL standard operators.

Note

Any SQL operators that aren't included in this list are not currently supported in QLDB.

Arithmetic operators

Operator Description
+ Add
- Subtract
* Multiply
/ Divide
% Modulo

Comparison operators

Operator Description
= Equal to
> Greater than
< Less than
>= Greater than or equal to
<= Less than or equal to
<> Not equal to

Logical operators

Operator Description
AND TRUE if all the conditions separated by AND are TRUE
BETWEEN TRUE if the operand is within the range of comparisons
IN TRUE if the operand is equal to one of a list of expressions
IS TRUE if the operand is a given data type, including NULL or MISSING
LIKE TRUE if the operand matches a pattern
NOT Reverses the value of a given Boolean expression
OR TRUE if any of the conditions separated by OR is TRUE

String operators

Operator Description
|| Concatenates two strings on either side of the || operator and returns the concatenated string. If one or both strings is NULL, the result of the concatenation is null.