PostgreSQL point(circle) Function

The PostgreSQL point(circle) function calculates the center point of the specified circle and returns that.

point(circle) Syntax

This is the syntax of the PostgreSQL point(circle) function:

point(circle) -> point

Parameters

circle

Required. A circle. For example: circle '<(0,0),2>'.

Return value

The PostgreSQL point(circle) function returns the center point of the circle specified by the parameter.

point(circle) Examples

The following statement shows how to use the PostgreSQL point(circle) function to return he center point of circle '<(0,0),2>'.

SELECT point(circle '<(0,0),2>');

 point
-------
 (0,0)

The following statement shows how to use the PostgreSQL point(circle) function to return the center point of circle '<(1,2),3>'.

SELECT point(circle '<(1,2),3>');

 point
-------
 (1,2)