Operadores

	Argumentos		Izquierdo	Derecho
!	int4		int4	fraction
!!		int4	int4	fraction
!!=	int4	name	bool	not in
!!=	oid	name	bool	not in
!~	bpchar	text	bool	does not match regex., case-sensitive
!~	name	text	bool	does not match regex., case-sensitive
!~	text	text	bool	does not match regex., case-sensitive
!~	varchar	text	bool	does not match regex., case-sensitive
!~*	bpchar	text	bool	does not match regex., case-insensitive
!~*	name	text	bool	does not match regex., case-insensitive
!~*	text	text	bool	does not match regex., case-insensitive
!~*	varchar	text	bool	does not match regex., case-insensitive
!~~	bpchar	text	bool	does not match LIKE expression
!~~	name	text	bool	does not match LIKE expression
!~~	text	text	bool	does not match LIKE expression
!~~	varchar	text	bool	does not match LIKE expression
#		path	int4
#		polygon	int4	number of points in polygon
#	box	box	box	intersects
#	line	line	point	intersection point
#	lseg	lseg	point
##	line	box	point	closest point to line on box
##	line	lseg	point	closest point to line on line segment
##	lseg	box	point	closest point to line segment on box
##	lseg	line	point	closest point to line segment on line
##	lseg	lseg	point	closest point to line segment on line seg
##	point	box	point	closest point on box
##	point	line	point	closest point on line
##	point	lseg	point	closest point on line segment
#<	tinterval	reltime	bool	length less-than
#<=	tinterval	reltime	bool	length less-than-or-equal
#<>	tinterval	reltime	bool	length not equal to
#=	tinterval	reltime	bool	length equal
#>	tinterval	reltime	bool	length greater-than
#>=	tinterval	reltime	bool	length greater-than-or-equal
%		float8	float8	truncate to integer
%	float8		float8	truncate to integer
%	int2	int2	int2	modulus
%	int2	int4	int4	modulus
%	int4	int2	int4	modulus
%	int4	int4	int4	modulus
%	numeric	numeric	numeric	modulus
&&	box	box	bool	overlaps
&&	circle	circle	bool	overlaps
&&	polygon	polygon	bool	overlaps
&&	tinterval	tinterval	bool	overlaps
&<	box	box	bool	overlaps, but does not extend to right of
&<	circle	circle	bool	overlaps, but does not extend to right of
&<	polygon	polygon	bool	overlaps, but does not extend to right of
&>	box	box	bool	overlaps, but does not extend to left of
&>	circle	circle	bool
&>	polygon	polygon	bool	overlaps, but does not extend to left of
*	box	point	box	multiply box by point (scale)
*	char	char	char	multiply
*	circle	point	circle	multiply
*	float4	float4	float4	multiply
*	float4	float8	float8	multiply
*	float4	money	money	multiply
*	float8	float4	float8	multiply
*	float8	float8	float8	multiply
*	float8	money	money	multiply
*	int2	int2	int2	multiply
*	int2	int4	int4	multiply
*	int2	money	money	multiply
*	int4	int2	int4	multiply
*	int4	int4	int4	multiply
*	int4	int8	int8	multiply
*	int4	money	money	multiply
*	int8	int4	int8	multiply
*	int8	int8	int8	multiply
*	money	float4	money	multiply
*	money	float8	money	multiply
*	money	int2	money	multiply
*	money	int4	money	multiply
*	numeric	numeric	numeric	multiply
*	path	point	path	multiply
*	point	point	point	multiply points (scale/rotate)
+	_aclitem	aclitem	_aclitem	addition
+	abstime	reltime	abstime	addition
+	box	point	box	add point to box (translate)
+	char	char	char	addition
+	circle	point	circle	addition
+	date	int4	date	addition
+	datetime	timespan	datetime	plus
+	float4	float4	float4	addition
+	float4	float8	float8	addition
+	float8	float4	float8	addition
+	float8	float8	float8	addition
+	int2	int2	int2	addition
+	int2	int4	int4	addition
+	int4	int2	int4	addition
+	int4	int4	int4	addition
+	int4	int8	int8	addition
+	int8	int4	int8	addition
+	int8	int8	int8	addition
+	money	money	money	addition
+	numeric	numeric	numeric	addition
+	path	path	path	addition
+	path	point	path	addition
+	point	point	point	add points (translate)
+	timespan	timespan	timespan	addition
-		float4	float4	subtract
-		float8	float8	subtract
-		int2	int2	subtract
-		int4	int4	subtract
-		int8	int8	unary minus
-		timespan	timespan	subtract
-	_aclitem	aclitem	_aclitem	subtract
-	abstime	reltime	abstime	subtract
-	box	point	box	subtract point from box (translate)
-	char	char	char	subtract
-	circle	point	circle	subtract
-	date	date	int4	subtract
-	date	int4	date	subtract
-	datetime	datetime	timespan	subtract
-	datetime	timespan	datetime	minus
-	float4	float4	float4	subtract
-	float4	float8	float8	subtract
-	float8	float4	float8	subtract
-	float8	float8	float8	subtract
-	int2	int2	int2	subtract
-	int2	int4	int4	subtract
-	int4	int2	int4	subtract
-	int4	int4	int4	subtract
-	int4	int8	int8	subtraction
-	int8	int4	int8	subtraction
-	int8	int8	int8	subtraction
-	money	money	money	subtract
-	numeric	numeric	numeric	subtract
-	path	point	path	subtract
-	point	point	point	subtract points (translate)
-	timespan	timespan	timespan	subtract
/	box	point	box	divide box by point (scale)
/	char	char	char	divide
/	circle	point	circle	divide
/	float4	float4	float4	divide
/	float4	float8	float8	divide
/	float8	float4	float8	divide
/	float8	float8	float8	divide
/	int2	int2	int2	divide
/	int2	int4	int4	divide
/	int4	int2	int4	divide
/	int4	int4	int4	divide
/	int4	int8	int8	divide
/	int8	int4	int8	divide
/	int8	int8	int8	divide
/	money	float4	money	divide
/	money	float8	money	divide
/	money	int2	money	divide
/	money	int4	money	divide
/	numeric	numeric	numeric	divide
/	path	point	path	divide
/	point	point	point	divide points (scale/rotate)
/	timespan	float8	timespan	divide
:		float8	float8	exponential
;		float8	float8	natural logarithm (in psql, protect with
<	abstime	abstime	bool	less-than
<	bool	bool	bool	less-than
<	box	box	bool	less-than
<	bpchar	bpchar	bool	less-than
<	char	char	bool	less-than
<	cidr	cidr	bool	less-than
<	circle	circle	bool	less-than
<	date	date	bool	less-than
<	datetime	datetime	bool	less-than
<	float4	float4	bool	less-than
<	float4	float8	bool	less-than
<	float8	float4	bool	less-than
<	float8	float8	bool	less-than
<	inet	inet	bool	less-than
<	int2	int2	bool	less-than
<	int2	int4	bool	less-than
<	int4	int2	bool	less-than
<	int4	int4	bool	less-than
<	int4	int8	bool	less-than
<	int8	int4	bool	less-than
<	int8	int8	bool	less-than
<	lseg	lseg	bool	less-than
<	macaddr	macaddr	bool	less-than
<	money	money	bool	less-than
<	name	name	bool	less-than
<	numeric	numeric	bool	lower-than
<	oid	oid	bool	less-than
<	oid8	oid8	bool	less-than
<	path	path	bool	less-than
<	reltime	reltime	bool	less-than
<	text	text	bool	less-than
<	time	time	bool	less-than
<	timespan	timespan	bool	less-than
<	timestamp	timestamp	bool	less-than
<	tinterval	tinterval	bool	less-than
<	varchar	varchar	bool	less-than
<#>	abstime	abstime	tinterval	convert to interval
<->	box	box	float8	distance between
<->	circle	circle	float8	distance between
<->	circle	polygon	float8	distance between
<->	line	box	float8	distance between
<->	line	line	float8	distance between
<->	lseg	box	float8	distance between
<->	lseg	line	float8	distance between
<->	lseg	lseg	float8	distance between
<->	path	path	float8	distance between
<->	point	box	float8	distance between
<->	point	circle	float8	distance between
<->	point	line	float8	distance between
<->	point	lseg	float8	distance between
<->	point	path	float8	distance between
<->	point	point	float8	distance between
<->	polygon	polygon	float8	distance between
<<	box	box	bool	is left of
<<	cidr	cidr	bool	is-subnet
<<	circle	circle	bool	is left of
<<	inet	inet	bool	is-subnet
<<	point	point	bool	is left of
<<	polygon	polygon	bool	is left of
<<	tinterval	tinterval	bool	less-than
<<=	cidr	cidr	bool	is-subnet-or-equal
<<=	inet	inet	bool	is-subnet-or-equal
<=	abstime	abstime	bool	less-than-or-equal
<=	box	box	bool	less-than-or-equal
<=	bpchar	bpchar	bool	less-than-or-equal
<=	char	char	bool	less-than-or-equal
<=	cidr	cidr	bool	less-than-or-equal
<=	circle	circle	bool	less-than-or-equal
<=	date	date	bool	less-than-or-equal
<=	datetime	datetime	bool	less-than-or-equal
<=	float4	float4	bool	less-than-or-equal
<=	float4	float8	bool	less-than-or-equal
<=	float8	float4	bool	less-than-or-equal
<=	float8	float8	bool	less-than-or-equal
<=	inet	inet	bool	less-than-or-equal
<=	int2	int2	bool	less-than-or-equal
<=	int2	int4	bool	less-than-or-equal
<=	int4	int2	bool	less-than-or-equal
<=	int4	int4	bool	less-than-or-equal
<=	int4	int8	bool	less-than-or-equal
<=	int8	int4	bool	less-than-or-equal
<=	int8	int8	bool	less-than-or-equal
<=	lseg	lseg	bool	less-than-or-equal
<=	macaddr	macaddr	bool	less-than-or-equal
<=	money	money	bool	less-than-or-equal
<=	name	name	bool	less-than-or-equal
<=	numeric	numeric	bool	lower-than-or-equal
<=	oid	oid	bool	less-than-or-equal
<=	oid8	oid8	bool	less-than-or-equal
<=	path	path	bool	less-than-or-equal
<=	reltime	reltime	bool	less-than-or-equal
<=	text	text	bool	less-than-or-equal
<=	time	time	bool	less-than-or-equal
<=	timespan	timespan	bool	less-than-or-equal
<=	timestamp	timestamp	bool	less-than-or-equal
<=	tinterval	tinterval	bool	less-than-or-equal
<=	varchar	varchar	bool	less-than-or-equal
<>	abstime	abstime	bool	not equal
<>	bool	bool	bool	not equal
<>	bpchar	bpchar	bool	not equal
<>	char	char	bool	not equal
<>	cidr	cidr	bool	not equal
<>	circle	circle	bool	not equal
<>	date	date	bool	not equal
<>	datetime	datetime	bool	not equal
<>	float4	float4	bool	not equal
<>	float4	float8	bool	not equal
<>	float8	float4	bool	not equal
<>	float8	float8	bool	not equal
<>	inet	inet	bool	not equal
<>	int2	int2	bool	not equal
<>	int2	int4	bool	not equal
<>	int4	int2	bool	not equal
<>	int4	int4	bool	not equal
<>	int4	int8	bool	not equal
<>	int8	int4	bool	not equal
<>	int8	int8	bool	not equal
<>	lseg	lseg	bool	not equal
<>	macaddr	macaddr	bool	not equal
<>	money	money	bool	not equal
<>	name	name	bool	not equal
<>	numeric	numeric	bool	not equal
<>	oid	oid	bool	not equal
<>	oid8	oid8	bool	less-than
<>	reltime	reltime	bool	not equal
<>	text	text	bool	not equal
<>	time	time	bool	not equal
<>	timespan	timespan	bool	not equal
<>	timestamp	timestamp	bool	not equal
<>	tinterval	tinterval	bool	not equal
<>	varchar	varchar	bool	not equal
<?>	abstime	tinterval	bool	abstime in tinterval
<^	box	box	bool	is below
<^	circle	circle	bool	is below
<^	point	point	bool	is below
=	_abstime	_abstime	bool	equal
=	_aclitem	_aclitem	bool	equal
=	_bool	_bool	bool	equal
=	_box	_box	bool	equal
=	_bytea	_bytea	bool	equal
=	_char	_char	bool	equal
=	_cid	_cid	bool	equal
=	_filename	_filename	bool	equal
=	_float4	_float4	bool	equal
=	_float8	_float8	bool	equal
=	_int2	_int2	bool	equal
=	_int28	_int28	bool	equal
=	_int4	_int4	bool	equal
=	_lseg	_lseg	bool	equal
=	_name	_name	bool	equal
=	_oid	_oid	bool	equal
=	_oid8	_oid8	bool	equal
=	_path	_path	bool	equal
=	_point	_point	bool	equal
=	_polygon	_polygon	bool	equal
=	_regproc	_regproc	bool	equal
=	_reltime	_reltime	bool	equal
=	_text	_text	bool	equal
=	_tid	_tid	bool	equal
=	_tinterval	_tinterval	bool	equal
=	_xid	_xid	bool	equal
=	abstime	abstime	bool	equal
=	bool	bool	bool	equal
=	box	box	bool	equal
=	bpchar	bpchar	bool	equal
=	char	char	bool	equal
=	cidr	cidr	bool	equal
=	circle	circle	bool	equal
=	date	date	bool	equal
=	datetime	datetime	bool	equal
=	float4	float4	bool	equal
=	float4	float8	bool	equal
=	float8	float4	bool	equal
=	float8	float8	bool	equal
=	inet	inet	bool	equal
=	int2	int2	bool	equal
=	int2	int4	bool	equal
=	int4	int2	bool	equal
=	int4	int4	bool	equal
=	int4	int8	bool	equal
=	int4	oid	bool	equal
=	int8	int4	bool	equal
=	int8	int8	bool	equal
=	line	line	bool	lines equal?
=	lseg	lseg	bool	equal
=	macaddr	macaddr	bool	equal
=	money	money	bool	equal
=	name	name	bool	equal
=	numeric	numeric	bool	equal
=	oid	int4	bool	equal
=	oid	oid	bool	equal
=	oid8	oid8	bool	equal
=	path	path	bool	equal
=	reltime	reltime	bool	equal
=	text	text	bool	equal
=	time	time	bool	equal
=	timespan	timespan	bool	equal
=	timestamp	timestamp	bool	equal
=	tinterval	tinterval	bool	equal
=	varchar	varchar	bool	equal
>	abstime	abstime	bool	greater-than
>	bool	bool	bool	greater-than
>	box	box	bool	greater-than
>	bpchar	bpchar	bool	greater-than
>	char	char	bool	greater-than
>	cidr	cidr	bool	greater-than
>	circle	circle	bool	greater-than
>	date	date	bool	greater-than
>	datetime	datetime	bool	greater-than
>	float4	float4	bool	greater-than
>	float4	float8	bool	greater-than
>	float8	float4	bool	greater-than
>	float8	float8	bool	greater-than
>	inet	inet	bool	greater-than
>	int2	int2	bool	greater-than
>	int2	int4	bool	greater-than
>	int4	int2	bool	greater-than
>	int4	int4	bool	greater-than
>	int4	int8	bool	greater-than
>	int8	int4	bool	greater-than
>	int8	int8	bool	greater-than
>	lseg	lseg	bool	greater-than
>	macaddr	macaddr	bool	greater-than
>	money	money	bool	greater-than
>	name	name	bool	greater-than
>	numeric	numeric	bool	greater-than
>	oid	oid	bool	greater-than
>	oid8	oid8	bool	greater-than
>	path	path	bool	greater-than
>	reltime	reltime	bool	greater-than
>	text	text	bool	greater-than
>	time	time	bool	greater-than
>	timespan	timespan	bool	greater-than
>	timestamp	timestamp	bool	greater-than
>	tinterval	tinterval	bool	greater-than
>	varchar	varchar	bool	greater-than
>=	abstime	abstime	bool	greater-than-or-equal
>=	box	box	bool	greater-than-or-equal
>=	bpchar	bpchar	bool	greater-than-or-equal
>=	char	char	bool	greater-than-or-equal
>=	cidr	cidr	bool	greater-than-or-equal
>=	circle	circle	bool	greater-than-or-equal
>=	date	date	bool	greater-than-or-equal
>=	datetime	datetime	bool	greater-than-or-equal
>=	float4	float4	bool	greater-than-or-equal
>=	float4	float8	bool	greater-than-or-equal
>=	float8	float4	bool	greater-than-or-equal
>=	float8	float8	bool	greater-than-or-equal
>=	inet	inet	bool	greater-than-or-equal
>=	int2	int2	bool	greater-than-or-equal
>=	int2	int4	bool	greater-than-or-equal
>=	int4	int2	bool	greater-than-or-equal
>=	int4	int4	bool	greater-than-or-equal
>=	int4	int8	bool	greater-than-or-equal
>=	int8	int4	bool	greater-than-or-equal
>=	int8	int8	bool	greater-than-or-equal
>=	lseg	lseg	bool	greater-than-or-equal
>=	macaddr	macaddr	bool	greater-than-or-equal
>=	money	money	bool	greater-than-or-equal
>=	name	name	bool	greater-than-or-equal
>=	numeric	numeric	bool	greater-than-or-equal
>=	oid	oid	bool	greater-than-or-equal
>=	oid8	oid8	bool	greater-than-or-equal
>=	path	path	bool	greater-than-or-equal
>=	reltime	reltime	bool	greater-than-or-equal
>=	text	text	bool	greater-than-or-equal
>=	time	time	bool	greater-than-or-equal
>=	timespan	timespan	bool	greater-than-or-equal
>=	timestamp	timestamp	bool	greater-than-or-equal
>=	tinterval	tinterval	bool	greater-than-or-equal
>=	varchar	varchar	bool	greater-than-or-equal
>>	box	box	bool	is left of
>>	cidr	cidr	bool	is-supernet
>>	circle	circle	bool	is left of
>>	inet	inet	bool	is-supernet
>>	point	point	bool	is left of
>>	polygon	polygon	bool	is left of
>>=	cidr	cidr	bool	is-supernet-or-equal
>>=	inet	inet	bool	is-supernet-or-equal
>^	box	box	bool	is above
>^	circle	circle	bool	is above
>^	point	point	bool	is above
?#	box	box	bool	overlaps
?#	line	box	bool
?#	line	line	bool	lines intersect?
?#	lseg	box	bool
?#	lseg	line	bool
?#	lseg	lseg	bool	intersects
?#	path	path	bool
?-		line	bool	lines horizontal?
?-		lseg	bool	is horizontal
?-	point	point	bool	is horizontal
?-|	line	line	bool	lines perpendicular?
?-|	lseg	lseg	bool	is perpendicular to
?|		line	bool	lines vertical?
?|		lseg	bool	is vertical
?|	point	point	bool	is vertical
?||	line	line	bool	lines parallel?
?||	lseg	lseg	bool	is parallel to
@		float4	float4	absolute value
@		float8	float8	absolute value
@		numeric	numeric	absolute value
@	box	box	bool	contained in
@	circle	circle	bool
@	lseg	box	bool	contained in
@	lseg	line	bool	contained in
@	point	box	bool	point is inside
@	point	circle	bool
@	point	line	bool	contained in
@	point	lseg	bool	contained in
@	point	path	bool	contained in
@	point	polygon	bool	point contained by polygon?
@	polygon	polygon	bool	contained in
@-@		lseg	float8	distance between endpoints
@-@		path	float8	sum of path segments
@@		box	point	center of
@@		circle	point	center of
@@		lseg	point	center of
@@		path	point	center of
@@		polygon	point	center of
^	float8	float8	float8	exponentiation
|		tinterval	abstime	start of interval
|/		float8	float8	square root
||	bpchar	bpchar	text	concatenate
||	text	text	text	concatenate
||	varchar	varchar	text	concatenate
||/		float8	float8	cube root
~	_aclitem	aclitem	bool	matches regex., case-sensitive
~	box	box	bool	contains
~	bpchar	text	bool	matches regex., case-sensitive
~	circle	circle	bool	contains
~	circle	point	bool
~	name	text	bool	matches regex., case-sensitive
~	path	point	bool	path contains point?
~	polygon	point	bool	polygon contains point?
~	polygon	polygon	bool	contains
~	text	text	bool	matches regex., case-sensitive
~	varchar	text	bool	matches regex., case-sensitive
~*	bpchar	text	bool	matches regex., case-insensitive
~*	name	text	bool	matches regex., case-insensitive
~*	text	text	bool	matches regex., case-insensitive
~*	varchar	text	bool	matches regex., case-insensitive
~=	box	box	bool	same as
~=	circle	circle	bool	same as
~=	point	point	bool	same as
~=	polygon	polygon	bool	same as
~=	tinterval	tinterval	bool	same as
~~	bpchar	text	bool	matches LIKE expression
~~	name	text	bool	matches LIKE expression
~~	text	text	bool	matches LIKE expression
~~	varchar	text	bool	matches LIKE expression