Version 1.0
SELECT * FROM nPath ( ON { table | view | (query) } PARTITION BY partition_column ORDER BY order_column [ ASC | DESC ] [ ON { table | view | (query) } [ PARTITION BY partition_column | DIMENSION ] ORDER BY order_column [ ASC | DESC ] ][...] Mode ({ OVERLAPPING | NONOVERLAPPING }) Pattern ('pattern') Symbols ( { col_expr = symbol_predicate AS symbol} [,...]) [ Filter (filter_expression[,...]) ] Result ({aggregate_function(col_expr OF symbol) AS alias}[,...]) );
The nPath function is not tied to any Aster Database schema and must not be qualified with a schema name.