StreamSQL Guide Conventions

Syntax descriptions in this guide use the following typographical conventions:

StreamSQL keywords

Shown in UPPERCASE font. Although StreamSQL is case insensitive with respect to keywords, StreamBase convention is to use uppercase characters for clarity.

Example: CREATE TABLE

Substitutable entries

Shown in lowercase monospace italic font. In StreamSQL applications, replace these placeholders with content suitable to the application. Any combination of upper and lower case characters is acceptable.

Example: CREATE INDEX index_identifier ON table_identifier

Brackets ( [ and ] )

Indicate optional content. If an optional entry is used, do not include the brackets in the StreamSQL application.

Example: SELECT ... FROM ... [WHERE ...]

The pipe symbol ( | )

Indicates a choice. In StreamSQL applications choose one of the alternatives separated by the symbol.

Example: CREATE [MEMORY | DISK] TABLE table_identifier

Parentheses

When present, are a required part of the StreamSQL syntax and must be entered as illustrated.

Example: PRIMARY KEY(column_identifier[,...])

Braces ( { and } )

Indicate that a choice must be made from multiple alternatives. In StreamSQL applications, do not include the braces.

Example: USING {HASH | BTREE}

Parentheses or brackets in quotes ( '(' and ')', '[' and ']' )

In some statements, parentheses or brackets are a required part of the StreamSQL syntax. In this case, each parenthesis or brace is shown within single quotation marks. In StreamSQL applications, the parentheses or brackets must be included.

Example: FROM stream_identifier '['window_specification']'

Brackets containing an ellipsis ( [, ...] )

Indicate optional repeated content. If optional additional entries are used, do not include the brackets in the StreamSQL application.

Example: SELECT field_identifier[, ...]

Is equivalent to: SELECT field_identifier_1, field_identifier_2, ..., where the ellipsis indicates additional optional entries.

Double hyphens ( -- )

Indicates a comment. In StreamSQL, comments extend to the end of the line.

Example: -- This comment extends to the end of the line.