Range

extension Range where Bound: SQLExpressible

Available where Bound: SQLExpressible

  • An SQL expression that checks the inclusion of an expression in a range.

    // email >= 'A' AND email < 'B'
("A"..<"B").contains(Column("email"))

    Declaration

    Swift

    public func contains(_ element: SQLSpecificExpressible) -> SQLExpression
    Show on GitHub

  • An SQL expression that checks the inclusion of an expression in a range.

    // email >= 'A' COLLATE NOCASE AND email < 'B' COLLATE NOCASE
("A"..<"B").contains(Column("email").collating(.nocase))

    Declaration

    Swift

    public func contains(_ element: SQLCollatedExpression) -> SQLExpression
    Show on GitHub