CompoundOperator enum

A set operator used to combine the results of multiple select statement into one.

Inheritance

• Object
• Enum
• CompoundOperator

Implemented types

• SqlComponent

Available extensions

• EnumName

Values

union → const CompoundOperator

A UNION operator, returning rows from both select statements (removing duplicates).

const CompoundOperator('UNION')

unionAll → const CompoundOperator

A UNION ALL operator, returning rows from both select statements without filtering duplicates.

const CompoundOperator('UNION ALL')

intersect → const CompoundOperator

An INTERSECT operator, returning only rows that are present in both select statements.

const CompoundOperator('INTERSECT')

except → const CompoundOperator

An EXCEPT operator, returning rows that are present in the first select statement but not the second.

const CompoundOperator('EXCEPT')

Properties

defaultLexeme → String

The lexeme this operator has on most SQL dialects.

final

hashCode → int

The hash code for this object.

no setter, inherited

index → int

A numeric identifier for the enumerated value.

no setter, inherited

name → String

Available on Enum, provided by the EnumName extension

The name of the enum value.

no setter

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

Methods

compileWith(StatementCompiler compiler) → void

Compiles this component with the given StatementCompiler by invoking the relevant add method on it.

override

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited

Constants

values → const List<CompoundOperator>

A constant List of the values in this enum, in order of their declaration.