bSQL functions
bSQL offers a suite of functions to be used over columns when querying data.
Categories of bSQL functions​
| FUNCTION CATEGORY | DESCRIPTION |
|---|---|
| Logical Functions | Perform logical operations. |
| Mathematical Functions | Perform calculations based on input values provided as parameters to the functions, and return numeric values. |
| String Functions | Perform operations on a string input value and return a string or numeric value. |
| Timestamp Functions | Perform operations on a timestamp input values and return string, numeric, or date and time values. |
| Conversion Functions | Support data type casting and converting. |
| Aggregate Functions | Perform a calculation on a set of values and return a single value. |
| Cryptographic Functions | These functions support digital signing, digital signature validation, encryption, and decryption. |
Example Blockchain​
For the purpose of the doc examples we will be using the following blockchain called example:
| INTEGER [INT32] | STR [STRING] | REAL [FLOAT32] | TIME [TIMESTAMP] | B [BOOL] |
|---|---|---|---|---|
| -1 | NULL | NULL | NULL | NULL |
| 0 | d | 0 | 2007-01-02 07:04:05.000000002 | false |
| 1 | lect | 1 | 2007-01-03 07:04:05.000000002 | true |
| 2 | dialect | 2 | 2007-01-04 07:04:05.000000002 | false |
string-functions