PostgreSQL bound_box() Function

The PostgreSQL bound_box() function returns the bounding box of two specified boxes.

bound_box() Syntax

This is the syntax of the PostgreSQL bound_box() function:

bound_box(box1, box2) -> box

Parameters

box1

Required. A box, for example: box '(1,1),(0,0)'.

box2

Required. A box, for example: box '(4,4),(3,3)'.

Return value

The PostgreSQL bound_box() function returns the bounding box of two specified boxes.

bound_box() Examples

The following statement shows how to use bound_box() function to get the bounding box of two specified boxes.

SELECT bound_box(box '(4,4),(3,3)', box '(1,1),(0,0)');

  bound_box
-------------
 (4,4),(0,0)