Applies to VAST Cluster 5.5.
Functions that return rows: series, unnest, repeating values and rows, and queries as tables.
Each function has its own page: syntax, what it does, NULLs and edge cases, examples with their output, how it runs in VAST, how to make it faster, limitations and errors, and similar functions. Names that the VAST Query Engine doesn't have are in all functions A-Z.
Series of numbers and timestamps
| Function |
What it does |
| generate_series (table function) |
Generate rows of integers or timestamps from a start to a stop, stop included with the generate_series table function. |
| range (table function) |
Generate rows of integers or timestamps from a start, a stop and a step with the range table function, which stops before the stop value. |
Repeated rows
| Function |
What it does |
| repeat_row |
Return a row of several values a given number of times with the repeat_row table function. |
| repeat (table function) |
Return the same value in a given number of rows with the repeat table function. |
Rows from a list
| Function |
What it does |
| unnest |
Turn a list into rows, one per element with unnest, in FROM or in the SELECT list of a query on a table. |
Queries and tables named in a string
| Function |
What it does |
| query_table |
Read a table, or several tables combined, whose names are given as strings, in the FROM clause of a VAST Query Engine query. |
| query |
Run a SELECT statement given as a string, in the FROM clause of a VAST Query Engine query, and get its rows as a table. |
See also