Search Results for

    Show / Hide Table of Contents

    Class NpgsqlRangeDbFunctionsExtensions

    Provides extension methods for supporting PostgreSQL translation.

    Inheritance
    object
    NpgsqlRangeDbFunctionsExtensions
    Namespace: Microsoft.EntityFrameworkCore
    Assembly: Npgsql.EntityFrameworkCore.PostgreSQL.dll
    Syntax
    public static class NpgsqlRangeDbFunctionsExtensions

    Methods

    | Improve this Doc View Source

    ContainedBy<T>(NpgsqlRange<T>, NpgsqlRange<T>)

    Determines whether a range is contained by a specified range.

    Declaration
    public static bool ContainedBy<T>(this NpgsqlRange<T> a, NpgsqlRange<T> b)
    Parameters
    Type Name Description
    NpgsqlRange<><T> a

    The specified range to locate in the range.

    NpgsqlRange<><T> b

    The range in which to locate the specified range.

    Returns
    Type Description
    bool

    true if the range contains the specified range; otherwise, false.

    Type Parameters
    Name Description
    T

    The type of the elements of a.

    | Improve this Doc View Source

    Contains<T>(NpgsqlRange<T>, T)

    Determines whether a range contains a specified value.

    Declaration
    public static bool Contains<T>(this NpgsqlRange<T> range, T value)
    Parameters
    Type Name Description
    NpgsqlRange<><T> range

    The range in which to locate the value.

    T value

    The value to locate in the range.

    Returns
    Type Description
    bool

    true if the range contains the specified value; otherwise, false.

    Type Parameters
    Name Description
    T

    The type of the elements of range.

    | Improve this Doc View Source

    Contains<T>(NpgsqlRange<T>, NpgsqlRange<T>)

    Determines whether a range contains a specified range.

    Declaration
    public static bool Contains<T>(this NpgsqlRange<T> a, NpgsqlRange<T> b)
    Parameters
    Type Name Description
    NpgsqlRange<><T> a

    The range in which to locate the specified range.

    NpgsqlRange<><T> b

    The specified range to locate in the range.

    Returns
    Type Description
    bool

    true if the range contains the specified range; otherwise, false.

    Type Parameters
    Name Description
    T

    The type of the elements of a.

    | Improve this Doc View Source

    DoesNotExtendLeftOf<T>(NpgsqlRange<T>, NpgsqlRange<T>)

    Determines whether a range does not extend to the left of another range.

    Declaration
    public static bool DoesNotExtendLeftOf<T>(this NpgsqlRange<T> a, NpgsqlRange<T> b)
    Parameters
    Type Name Description
    NpgsqlRange<><T> a

    The first range.

    NpgsqlRange<><T> b

    The second range.

    Returns
    Type Description
    bool

    true if the first range does not extend to the left of the second; otherwise, false.

    Type Parameters
    Name Description
    T

    The type of the elements of a.

    | Improve this Doc View Source

    DoesNotExtendRightOf<T>(NpgsqlRange<T>, NpgsqlRange<T>)

    Determines whether a range does not extend to the right of another range.

    Declaration
    public static bool DoesNotExtendRightOf<T>(this NpgsqlRange<T> a, NpgsqlRange<T> b)
    Parameters
    Type Name Description
    NpgsqlRange<><T> a

    The first range.

    NpgsqlRange<><T> b

    The second range.

    Returns
    Type Description
    bool

    true if the first range does not extend to the right of the second; otherwise, false.

    Type Parameters
    Name Description
    T

    The type of the elements of a.

    | Improve this Doc View Source

    Except<T>(NpgsqlRange<T>, NpgsqlRange<T>)

    Returns the set difference, which means the elements of one range that do not appear in a second range.

    Declaration
    public static NpgsqlRange<T> Except<T>(this NpgsqlRange<T> a, NpgsqlRange<T> b)
    Parameters
    Type Name Description
    NpgsqlRange<><T> a

    The first range.

    NpgsqlRange<><T> b

    The second range.

    Returns
    Type Description
    NpgsqlRange<><T>

    The elements that appear in the first range, but not the second range.

    Type Parameters
    Name Description
    T

    The type of the elements of a.

    | Improve this Doc View Source

    Intersect<T>(NpgsqlRange<T>, NpgsqlRange<T>)

    Returns the set intersection, which means elements that appear in each of two ranges.

    Declaration
    public static NpgsqlRange<T> Intersect<T>(this NpgsqlRange<T> a, NpgsqlRange<T> b)
    Parameters
    Type Name Description
    NpgsqlRange<><T> a

    The first range.

    NpgsqlRange<><T> b

    The second range.

    Returns
    Type Description
    NpgsqlRange<><T>

    A range containing the elements that appear in both ranges.

    Type Parameters
    Name Description
    T

    The type of the elements of a.

    | Improve this Doc View Source

    IsAdjacentTo<T>(NpgsqlRange<T>, NpgsqlRange<T>)

    Determines whether a range is adjacent to another range.

    Declaration
    public static bool IsAdjacentTo<T>(this NpgsqlRange<T> a, NpgsqlRange<T> b)
    Parameters
    Type Name Description
    NpgsqlRange<><T> a

    The first range.

    NpgsqlRange<><T> b

    The second range.

    Returns
    Type Description
    bool

    true if the ranges are adjacent; otherwise, false.

    Type Parameters
    Name Description
    T

    The type of the elements of a.

    | Improve this Doc View Source

    IsStrictlyLeftOf<T>(NpgsqlRange<T>, NpgsqlRange<T>)

    Determines whether a range is strictly to the left of another range.

    Declaration
    public static bool IsStrictlyLeftOf<T>(this NpgsqlRange<T> a, NpgsqlRange<T> b)
    Parameters
    Type Name Description
    NpgsqlRange<><T> a

    The first range.

    NpgsqlRange<><T> b

    The second range.

    Returns
    Type Description
    bool

    true if the first range is strictly to the left of the second; otherwise, false.

    Type Parameters
    Name Description
    T

    The type of the elements of a.

    | Improve this Doc View Source

    IsStrictlyRightOf<T>(NpgsqlRange<T>, NpgsqlRange<T>)

    Determines whether a range is strictly to the right of another range.

    Declaration
    public static bool IsStrictlyRightOf<T>(this NpgsqlRange<T> a, NpgsqlRange<T> b)
    Parameters
    Type Name Description
    NpgsqlRange<><T> a

    The first range.

    NpgsqlRange<><T> b

    The second range.

    Returns
    Type Description
    bool

    true if the first range is strictly to the right of the second; otherwise, false.

    Type Parameters
    Name Description
    T

    The type of the elements of a.

    | Improve this Doc View Source

    Merge<T>(NpgsqlRange<T>, NpgsqlRange<T>)

    Returns the smallest range which includes both of the given ranges.

    Declaration
    public static NpgsqlRange<T> Merge<T>(this NpgsqlRange<T> a, NpgsqlRange<T> b)
    Parameters
    Type Name Description
    NpgsqlRange<><T> a

    The first range.

    NpgsqlRange<><T> b

    The second range.

    Returns
    Type Description
    NpgsqlRange<><T>

    The smallest range which includes both of the given ranges.

    Type Parameters
    Name Description
    T

    The type of the elements of a.

    | Improve this Doc View Source

    Overlaps<T>(NpgsqlRange<T>, NpgsqlRange<T>)

    Determines whether a range overlaps another range.

    Declaration
    public static bool Overlaps<T>(this NpgsqlRange<T> a, NpgsqlRange<T> b)
    Parameters
    Type Name Description
    NpgsqlRange<><T> a

    The first range.

    NpgsqlRange<><T> b

    The second range.

    Returns
    Type Description
    bool

    true if the ranges overlap (share points in common); otherwise, false.

    Type Parameters
    Name Description
    T

    The type of the elements of a.

    | Improve this Doc View Source

    RangeAgg<T>(IEnumerable<NpgsqlRange<T>>)

    Computes the union of the non-null input ranges. Corresponds to the PostgreSQL range_agg aggregate function.

    Declaration
    public static NpgsqlRange<T>[] RangeAgg<T>(this IEnumerable<NpgsqlRange<T>> input)
    Parameters
    Type Name Description
    IEnumerable<><NpgsqlRange<><T>> input

    The ranges to be aggregated via union into a multirange.

    Returns
    Type Description
    NpgsqlRange<><T>[]
    Type Parameters
    Name Description
    T
    See Also
    PostgreSQL documentation for aggregate functions.
    | Improve this Doc View Source

    RangeIntersectAgg<T>(IEnumerable<NpgsqlRange<T>[]>)

    Computes the intersection of the non-null input multiranges. Corresponds to the PostgreSQL range_intersect_agg aggregate function.

    Declaration
    public static NpgsqlRange<T>[] RangeIntersectAgg<T>(this IEnumerable<NpgsqlRange<T>[]> input)
    Parameters
    Type Name Description
    IEnumerable<><NpgsqlRange<><T>[]> input

    The multiranges on which to perform the intersection operation.

    Returns
    Type Description
    NpgsqlRange<><T>[]
    Type Parameters
    Name Description
    T
    See Also
    PostgreSQL documentation for aggregate functions.
    | Improve this Doc View Source

    RangeIntersectAgg<T>(IEnumerable<NpgsqlRange<T>>)

    Computes the intersection of the non-null input ranges. Corresponds to the PostgreSQL range_intersect_agg aggregate function.

    Declaration
    public static NpgsqlRange<T> RangeIntersectAgg<T>(this IEnumerable<NpgsqlRange<T>> input)
    Parameters
    Type Name Description
    IEnumerable<><NpgsqlRange<><T>> input

    The ranges on which to perform the intersection operation.

    Returns
    Type Description
    NpgsqlRange<><T>
    Type Parameters
    Name Description
    T
    See Also
    PostgreSQL documentation for aggregate functions.
    | Improve this Doc View Source

    Union<T>(NpgsqlRange<T>, NpgsqlRange<T>)

    Returns the set union, which means unique elements that appear in either of two ranges.

    Declaration
    public static NpgsqlRange<T> Union<T>(this NpgsqlRange<T> a, NpgsqlRange<T> b)
    Parameters
    Type Name Description
    NpgsqlRange<><T> a

    The first range.

    NpgsqlRange<><T> b

    The second range.

    Returns
    Type Description
    NpgsqlRange<><T>

    A range containing the unique elements that appear in either range.

    Type Parameters
    Name Description
    T

    The type of the elements of a.

    • Improve this Doc
    • View Source
    In This Article
    Back to top © Copyright 2023 The Npgsql Development Team