The implementantion in sql of BoxSP. More...

Functions
boxsp	inboxsp (cstring)
	The function transforms a string to a BoxSP type. More...

cstring	outboxsp (boxsp)
	The function transforms a BoxSP to a string. More...

boxsp	recvboxsp (internal)

bytea	send (boxsp)

boolean	equals (boxsp boxa, boxsp boxb)
	The function checks if two boxs are equal. More...

integer	hash (boxsp box)

pointsp	getl (boxsp box)
	The function returns the low left point of the BoxSP. More...

integer	getlx (boxsp box)
	The function returns the x coordinate of the low left point of the BoxSP. More...

integer	getly (boxsp box)
	The function returns the y coordinate of the low left point of the BoxSP. More...

pointsp	geth (boxsp box)
	The function returns the high right point of the BoxSP. More...

integer	gethx (boxsp box)
	The function returns the x coordinate of the high right point of the BoxSP. More...

integer	gethy (boxsp box)
	The function returns the y coordinate of the high right point of the BoxSP. More...

boxsp	boxsp (integer lx, integer ly, integer hx, integer hy)
	The function creates a PointSP from 4 integers. More...

boxsp	boxsp (pointsp l, pointsp h)
	The function creates a BoxSP from two PointSP. More...

boxsp	clone (boxsp box)

Detailed Description

The implementantion in sql of BoxSP.

Author: Marios Vodas (mvoda.nosp@m.s@gm.nosp@m.ail.c.nosp@m.om).

BoxSP is a spatial data type used in Hermes

See also: Spatial data types

Function Documentation

boxsp boxsp	(	integer	lx,
		integer	ly,
		integer	hx,
		integer	hy
	)

The function creates a PointSP from 4 integers.

Parameters

[in]	lx	the x coordinate of the low left point
[in]	ly	the y coordinate of the low left point
[in]	hx	the x coordinate of the high right point
[in]	hy	the x coordinate of the high right point

Returns: BoxSP

boxsp boxsp	(	pointsp	l,
		pointsp	h
	)

The function creates a BoxSP from two PointSP.

Parameters

[in]	l	the low left point
[in]	h	the high right point

Returns: BoxSP

boxsp clone ( boxsp box )

boolean equals	(	boxsp	boxa,
		boxsp	boxb
	)

The function checks if two boxs are equal.

Parameters

[in]	boxA	the first input box
[in]	boxB	the second input box

Returns: truth if the boxs are equal else false

pointsp geth ( boxsp box )

The function returns the high right point of the BoxSP.

Parameters

[in] box The BoxSP

Returns: the point

See also: get

integer gethx ( boxsp box )

The function returns the x coordinate of the high right point of the BoxSP.

Parameters

[in] box The BoxSP

Returns: the coordinate

See also: get

integer gethy ( boxsp box )

The function returns the y coordinate of the high right point of the BoxSP.

Parameters

[in] box The BoxSP

Returns: the coordinate

See also: get

pointsp getl ( boxsp box )

The function returns the low left point of the BoxSP.

Parameters

[in] box The BoxSP

Returns: the point

See also: get

integer getlx ( boxsp box )

The function returns the x coordinate of the low left point of the BoxSP.

Parameters

[in] box The BoxSP

Returns: the coordinate

See also: get

integer getly ( boxsp box )

The function returns the y coordinate of the low left point of the BoxSP.

Parameters

[in] box The BoxSP

Returns: the coordinate

See also: get

integer hash ( boxsp box )

boxsp inboxsp ( cstring )

The function transforms a string to a BoxSP type.

Parameters

[in] cstring the box in string format

Returns: BoxSP

cstring outboxsp ( boxsp )

The function transforms a BoxSP to a string.

Parameters

[in] BoxSP the input box

Returns: the string of the box

boxsp recvboxsp ( internal )

bytea send ( boxsp )

Functions

Detailed Description

Function Documentation