picoSQL - Language reference manual

5) Functions

picoSQL has a group of built-in functions to return data from database. Function are of two kind: simple functions and aggregate functions.
Aggregate functions summarize data over a group of rows from database and return numeric, string or time values.
Simple functions execute computation on one ore more arguments and act on numeric, string or date/time values. Simple functions can be numeric functions, string functions or date/time functions.