Class: WindowSpec

Defined in: lang-sql/src/ast/window.ts:30

Window specification for a window function or OVER clause.

Implements

• ASTNode

Constructors

Constructor

new WindowSpec(mode?, start?, end?, exclude?): WindowSpec

Defined in: lang-sql/src/ast/window.ts:40

Parameters

Parameter	Type	Default value	Description
mode?	string	undefined	-
start?	ASTNode	undefined	Frame start boundary expression.
end?	ASTNode	undefined	Frame end boundary expression; undefined for a single-sided frame.
exclude?	FrameExclusion	FrameExclusion.NO_OTHERS	Which rows are excluded from the frame.

Returns

WindowSpec

Properties

columns

columns: ASTNode[]

Defined in: lang-sql/src/ast/window.ts:38

PARTITION BY expressions.

---

end?

optional end?: ASTNode

Defined in: lang-sql/src/ast/window.ts:45

Frame end boundary expression; undefined for a single-sided frame.

---

exclude

exclude: FrameExclusion = FrameExclusion.NO_OTHERS

Defined in: lang-sql/src/ast/window.ts:47

Which rows are excluded from the frame.

---

mode

mode: FrameMode = FrameMode.ROWS

Defined in: lang-sql/src/ast/window.ts:32

Frame mode; defaults to ROWS.

---

order

order: OrderByItem[]

Defined in: lang-sql/src/ast/window.ts:36

ORDER BY expressions within the window.

---

parent

parent: string

Defined in: lang-sql/src/ast/window.ts:34

Name of the window this spec inherits from; undefined if standalone.

---

start?

optional start?: ASTNode

Defined in: lang-sql/src/ast/window.ts:43

Frame start boundary expression.

Methods

accept()

accept<Ret, Arg>(visitor, arg?): Ret

Defined in: lang-sql/src/ast/window.ts:52

Dispatches this node to the matching method on visitor.

Type Parameters

Type Parameter
Ret
Arg

Parameters

Parameter	Type
visitor	SQLVisitor<Ret, Arg>
arg?	Arg

Returns

Ret

Implementation of

ASTNode.accept