Class TPivotClause

Namespace

gudusoft.gsqlparser.nodes

Assembly

gudusoft.gsqlparser.dll

use the PIVOT and UNPIVOT relational operators to change a table-valued expression into another table.

public class TPivotClause : TNodeWithAliasClause, Visitable

Inheritance

object

TParseTreeNode

TNodeWithAliasClause

TPivotClause

Implements

Visitable

Inherited Members

TNodeWithAliasClause.AliasClause

TNodeWithAliasClause.ToString()

TParseTreeNode.dbvendor

TParseTreeNode.IsIncludingOriginalTokens()

TParseTreeNode.setChanged()

TParseTreeNode.IsUnderlyingTokenChanged()

TParseTreeNode.Gsqlparser

TParseTreeNode.IncludingComment

TParseTreeNode.DummyTag

TParseTreeNode.startToken

TParseTreeNode.getStartToken()

TParseTreeNode.getEndToken()

TParseTreeNode.endToken

TParseTreeNode.ColumnNo

TParseTreeNode.LineNo

TParseTreeNode.NodeType

TParseTreeNode.init(object)

TParseTreeNode.init(object, object, object, object)

TParseTreeNode.init(object, object, object, object, object)

TParseTreeNode.init(object, object, object, object, object, object)

TParseTreeNode.setStartToken(TSourceToken)

TParseTreeNode.setStartToken(TParseTreeNode)

TParseTreeNode.setStartToken<T>(List<T>)

TParseTreeNode.setEndToken(TSourceToken)

TParseTreeNode.setEndToken(TParseTreeNode)

TParseTreeNode.setEndToken<T>(List<T>)

TParseTreeNode._stringValue

TParseTreeNode.String

TParseTreeNode.SourceTokenList

TParseTreeNode.ToString(bool)

TParseTreeNode.ToScript()

TParseTreeNode.addAllMyTokensToTokenList(TSourceTokenList, int)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

Fields

pivot

public const int pivot = 1

Field Value

int

unpivot

public const int unpivot = 2

Field Value

int

Properties

Aggregation_function

public virtual TFunctionCall Aggregation_function { get; set; }

Property Value

TFunctionCall

Is a system or user-defined aggregate function that accepts one or more inputs.

Aggregation_function_list

public virtual TResultColumnList Aggregation_function_list { get; set; }

Property Value

TResultColumnList

ColumnList

public virtual TObjectNameList ColumnList { get; set; }

Property Value

TObjectNameList

In the PIVOT clause, lists the values in the pivot_column that will become the column names of the output table. The list cannot specify any column names that already exist in the input table_source that is being pivoted. In the UNPIVOT clause, lists the columns in table_source that will be narrowed into a single pivot_column.

In_result_list

public virtual TResultColumnList In_result_list { get; }

Property Value

TResultColumnList

result column list

PivotColumn

public virtual TObjectName PivotColumn { get; }

Property Value

TObjectName

Is the pivot column of the PIVOT operator.

PivotColumnList

public virtual TObjectNameList PivotColumnList { get; set; }

Property Value

TObjectNameList

PivotInClause

public virtual TPivotInClause PivotInClause { get; set; }

Property Value

TPivotInClause

Type

public virtual int Type { get; set; }

Property Value

int

UnpivotInClause

public virtual TUnpivotInClause UnpivotInClause { get; set; }

Property Value

TUnpivotInClause

ValueColumn

[Obsolete("use ValueColumnList instead")]
public virtual TObjectName ValueColumn { get; }

Property Value

TObjectName

Is the value column of the PIVOT operator. When used with UNPIVOT, value_column cannot be the name of an existing column in the input table_source.

ValueColumnList

public virtual TObjectNameList ValueColumnList { get; set; }

Property Value

TObjectNameList

Methods

accept(TParseTreeVisitor)

public override void accept(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

acceptChildren(TParseTreeVisitor)

public override void acceptChildren(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

doParse(TCustomSqlStatement, ESqlClause)

analyze this node

public override void doParse(TCustomSqlStatement psql, ESqlClause plocation)

Parameters

psql TCustomSqlStatement

plocation ESqlClause

init(object, object)

public override void init(object arg1, object arg2)

Parameters

arg1 object

arg2 object

init(object, object, object)

public override void init(object arg1, object arg2, object arg3)

Parameters

arg1 object

arg2 object

arg3 object