Built-in Function Call
AttentionThis page documents an earlier version. Go to the latest (v2.1)version.
Synopsis
Function call expression applies the specified function to to given arguments between parentheses and return the result of the computation.
Syntax
function_call ::= function_name '(' [ arguments ... ] ')'
Builtin Functions
Function | Return Type | Argument Type | Description |
---|---|---|---|
BlobAs<Type> | <Type> | (BLOB ) | Converts a value from BLOB |
<Type>AsBlob | BLOB | (<Type>) | Converts a value to BLOB |
DateOf | TIMESTAMP | (TIMEUUID ) | Conversion |
MaxTimeUuid | TIMEUUID | (TIMESTAMP ) | Returns the associated max time uuid |
MinTimeUuid | TIMEUUID | (TIMESTAMP ) | Returns the associated min time uuid |
Now | TIMEUUID | () | Returns the UUID of the current timestamp |
TTL | BIGINT | ( | Seek time-to-live of a column |
ToDate | DATE | (TIMESTAMP ) | Conversion |
ToDate | DATE | (TIMEUUID ) | Converts TIMEUUID to DATE |
ToTime | TIME | (TIMESTAMP ) | Conversion |
ToTime | TIME | (TIMEUUID | Conversion |
ToTimestamp | (TIMESTAMP ) | (DATE ) | Conversion |
ToTimestamp | (TIMESTAMP ) | (TIMEUUID ) | Conversion |
ToUnixTimestamp | BIGINT | (DATE ) | Conversion |
ToUnixTimestamp | BIGINT | (TIMESTAMP ) | Conversion |
ToUnixTimestamp | BIGINT | (TIMEUUID ) | Conversion |
UnixTimestampOf | BIGINT | (TIMEUUID ) | Conversion |
WriteTime | BIGINT | ( | Returns the time when the column was written |
Aggregate Functions
Function | Description |
---|---|
COUNT | Returns number of selected rows |
SUM | Returns sums of column values |
AVG | Returns the average of column values |
MIN | Returns the minimum value of column values |
MAX | Returns the maximum value of column values |
Semantics
- The argument datatypes must be convertible to the expected type for that argument that was specified by the function definition.
- Function execution will return a value of the specified type by the function definition.
- Yugabyte allows function calls to be used any where that expression is allowed.
See Also
当前内容版权归 YugabyteDB 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 YugabyteDB .