Schema documentation for component interval_value

Showing:

Diagrams

Instances

Model

Properties

Source

Used by

Element interval_value_expression

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content

complex

Used by

Elements	common_value_expression, datetime_value_expression/interval_value_expression_plus_datetime_term, extract_source, interval_absolute_value_function, interval_value_expression_1, set_time_zone_value
Element Group	scalar_expressions

Model

interval_term | interval_value_expression_plus_interval_term | interval_value_expression_minus_interval_term | datetime_value_expression_minus_datetime_term

Children

datetime_value_expression_minus_datetime_term, interval_term, interval_value_expression_minus_interval_term, interval_value_expression_plus_interval_term

Instance

<interval_value_expression xmlns="http://www.sqlparser.com/xml/ansi2003">
  <interval_term>{1,1}</interval_term>
  <interval_value_expression_plus_interval_term>{1,1}</interval_value_expression_plus_interval_term>
  <interval_value_expression_minus_interval_term>{1,1}</interval_value_expression_minus_interval_term>
  <datetime_value_expression_minus_datetime_term>{1,1}</datetime_value_expression_minus_datetime_term>
</interval_value_expression>

Source

<xs:element name="interval_value_expression">
  <xs:complexType>
    <xs:choice>
      <xs:element ref="interval_term"/>
      <xs:element name="interval_value_expression_plus_interval_term">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="interval_value_expression_1"/>
            <xs:element ref="interval_term_1"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="interval_value_expression_minus_interval_term">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="interval_value_expression_1"/>
            <xs:element ref="interval_term_1"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="datetime_value_expression_minus_datetime_term">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="datetime_value_expression"/>
            <xs:element ref="datetime_term"/>
            <xs:element ref="interval_qualifier"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:choice>
  </xs:complexType>
</xs:element>

Element interval_value_expression / interval_value_expression_plus_interval_term

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content

complex

Model

interval_value_expression_1 , interval_term_1

Children

interval_term_1, interval_value_expression_1

Instance

<interval_value_expression_plus_interval_term xmlns="http://www.sqlparser.com/xml/ansi2003">
  <interval_value_expression_1>{1,1}</interval_value_expression_1>
  <interval_term_1>{1,1}</interval_term_1>
</interval_value_expression_plus_interval_term>

Source

<xs:element name="interval_value_expression_plus_interval_term">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="interval_value_expression_1"/>
      <xs:element ref="interval_term_1"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element interval_value_expression / interval_value_expression_minus_interval_term

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content

complex

Model

interval_value_expression_1 , interval_term_1

Children

interval_term_1, interval_value_expression_1

Instance

<interval_value_expression_minus_interval_term xmlns="http://www.sqlparser.com/xml/ansi2003">
  <interval_value_expression_1>{1,1}</interval_value_expression_1>
  <interval_term_1>{1,1}</interval_term_1>
</interval_value_expression_minus_interval_term>

Source

<xs:element name="interval_value_expression_minus_interval_term">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="interval_value_expression_1"/>
      <xs:element ref="interval_term_1"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element interval_value_expression / datetime_value_expression_minus_datetime_term

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content

complex

Model

datetime_value_expression , datetime_term , interval_qualifier

Children

datetime_term, datetime_value_expression, interval_qualifier

Instance

<datetime_value_expression_minus_datetime_term xmlns="http://www.sqlparser.com/xml/ansi2003">
  <datetime_value_expression>{1,1}</datetime_value_expression>
  <datetime_term>{1,1}</datetime_term>
  <interval_qualifier>{1,1}</interval_qualifier>
</datetime_value_expression_minus_datetime_term>

Source

<xs:element name="datetime_value_expression_minus_datetime_term">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="datetime_value_expression"/>
      <xs:element ref="datetime_term"/>
      <xs:element ref="interval_qualifier"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>