Method SQL

pkg/sql/ast/sql.go:232–255

SQL returns the SQL representation of this CASE expression including all WHEN/THEN clauses and an optional ELSE clause.

()

// SQL returns the SQL representation of this CASE expression including all
// WHEN/THEN clauses and an optional ELSE clause.
func (c *CaseExpression) SQL() string {
	if c == nil {
		return ""
	}
	sb := getBuilder()
	defer putBuilder(sb)
	sb.WriteString("CASE")
	if c.Value != nil {
		sb.WriteString(" ")
		sb.WriteString(exprSQL(c.Value))
	}
	for _, w := range c.WhenClauses {
		sb.WriteString(" WHEN ")
		sb.WriteString(exprSQL(w.Condition))
		sb.WriteString(" THEN ")
		sb.WriteString(exprSQL(w.Result))
	}
	if c.ElseClause != nil {
		sb.WriteString(" ELSE ")
		sb.WriteString(exprSQL(c.ElseClause))
	}
	sb.WriteString(" END")
	return sb.String()
}

// SQL returns the SQL representation of this WHEN clause in the form
// "WHEN condition THEN result".