next up previous contents index
Next: Cursores Up: Algunas características de PostgreSQL Previous: Funciones incluidas en PostgreSQL   Índice General   Índice de Materias

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


next up previous contents index
Next: Cursores Up: Algunas características de PostgreSQL Previous: Funciones incluidas en PostgreSQL   Índice General   Índice de Materias
Ismael Olea 2001-04-21