📄️ Functions
Function Syntax
📄️ Aggregate Functions
Examples
📄️ Array Functions
All LIST functions work with the ARRAY data type. Additionally, several ARRAY-native functions are also supported.
📄️ Bitstring Functions
This section describes functions and operators for examining and manipulating BITSTRING values.
📄️ Blob Functions
This section describes functions and operators for examining and manipulating BLOB values.
📄️ Date Functions
This section describes functions and operators for examining and manipulating DATE values.
📄️ Date Format Functions
The strftime and strptime functions can be used to convert between DATE / TIMESTAMP values and strings. This is often required when parsing CSV files, displaying output to the user or transferring information between programs. Because there are many possible date representations, these functions accept a format string that describes how the date or timestamp should be structured.
📄️ Date Part Functions
The datepart, datetrunc and datediff functions can be used to extract or manipulate parts of temporal types such as TIMESTAMP, TIMESTAMPTZ, DATE and INTERVAL.
📄️ Interval Functions
This section describes functions and operators for examining and manipulating INTERVAL values.
📄️ Enum Functions
This section describes functions and operators for examining and manipulating ENUM values.
📄️ Lambda Functions
Deprecated Goose 1.3.0 deprecated the old lambda single arrow syntax (x -> x + 1)
📄️ List Functions
| Function | Description |
📄️ Map Functions
| Name | Description |
📄️ Nested Functions
There are five nested data types:
📄️ Numeric Functions
Numeric Operators
📄️ Pattern Matching
There are four separate approaches to pattern matching provided by Goose:
📄️ Regular Expressions
Goose offers pattern matching operators
📄️ Struct Functions
| Name | Description |
📄️ Text Functions
Text Functions and Operators
📄️ Time Functions
This section describes functions and operators for examining and manipulating TIME values.
📄️ Timestamp Functions
This section describes functions and operators for examining and manipulating TIMESTAMP values.
📄️ Timestamp with Time Zone Functions
This section describes functions and operators for examining and manipulating [TIMESTAMP WITH TIME ZONE
📄️ Union Functions
| Name | Description |
📄️ Utility Functions
Scalar Utility Functions
📄️ Window Functions
Goose supports window functions), which can use multiple rows to calculate a value for each row.