Enum SetOperator

    • Enum Constant Detail

      • UNION

        public static final SetOperator UNION
        Union of sets that removes duplicate rows.
      • UNION_ALL

        public static final SetOperator UNION_ALL
        Union of bags that retains all elements.
      • INTERSECT

        public static final SetOperator INTERSECT
        Intersection of sets that removes duplicate rows.
      • INTERSECT_ALL

        public static final SetOperator INTERSECT_ALL
        Intersection of bags that retains duplicate matches.
      • EXCEPT

        public static final SetOperator EXCEPT
        Exclusion of set elements of the set on the right-hand side.
      • EXCEPT_ALL

        public static final SetOperator EXCEPT_ALL
        Exclusion of bag elements of the bag on the right-hand side that retains duplicates.
    • Method Detail

      • values

        public static SetOperator[] values()
        Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
        for (SetOperator c : SetOperator.values())
            System.out.println(c);
        
        Returns:
        an array containing the constants of this enum type, in the order they are declared
      • valueOf

        public static SetOperator valueOf​(String name)
        Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
        Parameters:
        name - the name of the enum constant to be returned.
        Returns:
        the enum constant with the specified name
        Throws:
        IllegalArgumentException - if this enum type has no constant with the specified name
        NullPointerException - if the argument is null
      • sqlString

        public String sqlString()