api-docs / org.ktorm.support.postgresql / earthBox

earthBox

fun earthBox(
    point: ColumnDeclaring<Earth>,
    radius: ColumnDeclaring<Double>
): FunctionExpression<Cube>

(source code)

fun earthBox(
    point: ColumnDeclaring<Earth>,
    radius: Double
): FunctionExpression<Cube>

(source code)

fun earthBox(
    point: Earth,
    radius: ColumnDeclaring<Double>
): FunctionExpression<Cube>

(source code)

fun earthBox(
    point: Earth,
    radius: Double
): FunctionExpression<Cube>

(source code)

Returns a box suitable for an indexed search using the cube @> operator for points within a given great circle
distance of a location. Some points in this box are further than the specified great circle distance from the
location, so a second check using earth_distance should be included in the query.

Function from earthdistance extension, earth_box(point, radius) in SQL.