Help pg_dump: failed sanity check - Mailing list pgsql-sql
| From | Nisai Wanakule |
|---|---|
| Subject | Help pg_dump: failed sanity check |
| Date | |
| Msg-id | 000d01bef3de$957589b0$ed1104d1@kuhn-tucker.waterauthority.state.fl.us Whole thread Raw |
| List | pgsql-sql |
In an attemp to move to 6.5.1 I did pg_dumpall an get the following message:
postgres@lagrange:pgsql 23$ pg_dumpall >/opt3/db.out
failed sanity check, type with oid 227715 was not found
pg_dump failed on oropdata, exiting
postgres@lagrange:pgsql 23$ pg_dumpall >/opt3/db.out
failed sanity check, type with oid 227715 was not found
pg_dump failed on oropdata, exiting
I went ahead and did pg_dump -v on the problem database and seem that oid 227715
is one of user-defined function:
-- dumping out user-defined procedural languages
-- dumping out user-defined functions
failed sanity check, type with oid 227715 was not found
The trouble is I don't know what function to look for. How can I go about to identify
-- dumping out user-defined functions
failed sanity check, type with oid 227715 was not found
The trouble is I don't know what function to look for. How can I go about to identify
the function that contain the type with oid 227715?
TIA
Nisai
TIA
Nisai
Here is the list of functions in psql when connected to the problem database:
result |function |arguments |description
---------+-------------------+--------------+----------------------------------
_aclitem |aclinsert |_aclitem aclit|addition
_aclitem |aclremove |_aclitem aclit|subtract
abstime |abstime |abstime |convert
abstime |abstime |datetime |convert
abstime |datetime_abstime |datetime |convert datetime to abstime
abstime |intervalend |tinterval |
abstime |intervalstart |tinterval |start of interval
abstime |timemi |abstime reltim|subtract
abstime |timenow | |(internal)
abstime |timepl |abstime reltim|addition
bool |abstime_finite |abstime |
bool |abstimeeq |abstime abstim|equal
bool |abstimege |abstime abstim|greater-than-or-equal
bool |abstimegt |abstime abstim|greater-than
bool |abstimele |abstime abstim|less-than-or-equal
bool |abstimelt |abstime abstim|less-than
bool |abstimene |abstime abstim|not equal
bool |aclcontains |_aclitem aclit|matches regex., case-sensitive
bool |booleq |bool bool |equal
bool |boolgt |bool bool |greater-than
bool |boollt |bool bool |less-than
bool |boolne |bool bool |not equal
bool |box_above |box box |is above
bool |box_below |box box |is below
bool |box_contain |box box |contains
bool |box_contained |box box |contained in
bool |box_eq |box box |equal
bool |box_ge |box box |greater-than-or-equal
bool |box_gt |box box |greater-than
bool |box_le |box box |less-than-or-equal
bool |box_left |box box |is left of
bool |box_lt |box box |less-than
bool |box_overlap |box box |overlaps
bool |box_overleft |box box |overlaps, but does not extend to r
bool |box_overright |box box |overlaps, but does not extend to l
bool |box_right |box box |is left of
bool |box_same |box box |same as
bool |bpchareq |bpchar bpchar |equal
bool |bpcharge |bpchar bpchar |greater-than-or-equal
bool |bpchargt |bpchar bpchar |greater-than
bool |bpcharle |bpchar bpchar |less-than-or-equal
bool |bpcharlt |bpchar bpchar |less-than
bool |bpcharne |bpchar bpchar |not equal
bool |cash_eq |money money |equal
bool |cash_ge |money money |greater-than-or-equal
bool |cash_gt |money money |greater-than
bool |cash_le |money money |less-than-or-equal
bool |cash_lt |money money |less-than
bool |cash_ne |money money |not equal
bool |chareq |char char |equal
bool |charge |char char |greater-than-or-equal
bool |chargt |char char |greater-than
bool |charle |char char |less-than-or-equal
bool |charlt |char char |less-than
bool |charne |char char |not equal
bool |cideq |cid cid |equal
bool |circle_above |circle circle |is above
bool |circle_below |circle circle |is below
bool |circle_contain |circle circle |contains
bool |circle_contain_pt |circle point |
bool |circle_contained |circle circle |
bool |circle_eq |circle circle |equal
bool |circle_ge |circle circle |greater-than-or-equal
bool |circle_gt |circle circle |greater-than
bool |circle_le |circle circle |less-than-or-equal
bool |circle_left |circle circle |is left of
bool |circle_lt |circle circle |less-than
bool |circle_ne |circle circle |not equal
bool |circle_overlap |circle circle |overlaps
bool |circle_overleft |circle circle |overlaps, but does not extend to r
bool |circle_overright |circle circle |
bool |circle_right |circle circle |is left of
bool |circle_same |circle circle |same as
bool |date_eq |date date |equal
bool |date_ge |date date |greater-than-or-equal
bool |date_gt |date date |greater-than
bool |date_le |date date |less-than-or-equal
bool |date_lt |date date |less-than
bool |date_ne |date date |not equal
bool |datetime_eq |datetime datet|equal
bool |datetime_finite |datetime |
bool |datetime_ge |datetime datet|greater-than-or-equal
bool |datetime_gt |datetime datet|greater-than
bool |datetime_le |datetime datet|less-than-or-equal
bool |datetime_lt |datetime datet|less-than
bool |datetime_ne |datetime datet|not equal
bool |float48eq |float4 float8 |equal
bool |float48ge |float4 float8 |greater-than-or-equal
bool |float48gt |float4 float8 |greater-than
bool |float48le |float4 float8 |less-than-or-equal
bool |float48lt |float4 float8 |less-than
bool |float48ne |float4 float8 |not equal
bool |float4eq |float4 float4 |equal
bool |float4ge |float4 float4 |greater-than-or-equal
bool |float4gt |float4 float4 |greater-than
bool |float4le |float4 float4 |less-than-or-equal
bool |float4lt |float4 float4 |less-than
bool |float4ne |float4 float4 |not equal
bool |float84eq |float8 float4 |equal
bool |float84ge |float8 float4 |greater-than-or-equal
bool |float84gt |float8 float4 |greater-than
bool |float84le |float8 float4 |less-than-or-equal
bool |float84lt |float8 float4 |less-than
bool |float84ne |float8 float4 |not equal
bool |float8eq |float8 float8 |equal
bool |float8ge |float8 float8 |greater-than-or-equal
bool |float8gt |float8 float8 |greater-than
bool |float8le |float8 float8 |less-than-or-equal
bool |float8lt |float8 float8 |less-than
bool |float8ne |float8 float8 |not equal
bool |ininterval |abstime tinter|abstime in tinterval
bool |int2eq |int2 int2 |equal
bool |int2ge |int2 int2 |greater-than-or-equal
bool |int2gt |int2 int2 |greater-than
bool |int2le |int2 int2 |less-than-or-equal
bool |int2lt |int2 int2 |less-than
bool |int2ne |int2 int2 |not equal
bool |int48eq |int2 int8 |equal
bool |int48ge |int2 int8 |greater-than-or-equal
bool |int48gt |int2 int8 |greater-than
bool |int48le |int2 int8 |less-than-or-equal
bool |int48lt |int2 int8 |less-than
bool |int48ne |int2 int8 |not equal
bool |int4eq |int4 int4 |equal
bool |int4eqoid |int4 oid |equal
bool |int4ge |int4 int4 |greater-than-or-equal
bool |int4gt |int4 int4 |greater-than
bool |int4le |int4 int4 |less-than-or-equal
bool |int4lt |int4 int4 |less-than
bool |int4ne |int4 int4 |not equal
bool |int4notin |int2 |not in
bool |int84eq |int8 int4 |equal
bool |int84ge |int8 int4 |greater-than-or-equal
bool |int84gt |int8 int4 |greater-than
bool |int84le |int8 int4 |less-than-or-equal
bool |int84lt |int8 int4 |less-than
bool |int84ne |int8 int4 |not equal
bool |int8eq |int8 int8 |equal
bool |int8ge |int8 int8 |greater-than-or-equal
bool |int8gt |int8 int8 |greater-than
bool |int8le |int8 int8 |less-than-or-equal
bool |int8lt |int8 int8 |less-than
bool |int8ne |int8 int8 |not equal
bool |inter_lb |line box |
bool |inter_sb |lseg box |
bool |inter_sl |lseg line |
bool |intervalct |tinterval tint|less-than
bool |intervaleq |tinterval tint|equal
bool |intervalge |tinterval tint|greater-than-or-equal
bool |intervalgt |tinterval tint|greater-than
bool |intervalle |tinterval tint|less-than-or-equal
bool |intervalleneq |tinterval relt|length equal
bool |intervallenge |tinterval relt|length greater-than-or-equal
bool |intervallengt |tinterval relt|length greater-than
bool |intervallenle |tinterval relt|length less-than-or-equal
bool |intervallenlt |tinterval relt|length less-than
bool |intervallenne |tinterval relt|length not equal to
bool |intervallt |tinterval tint|less-than
bool |intervalne |tinterval tint|not equal
bool |intervalov |tinterval tint|overlaps
bool |intervalsame |tinterval tint|same as
bool |isclosed |path |
bool |isfalse |bool |
bool |isfinite |abstime |boolean test
bool |isfinite |datetime |boolean test
bool |isfinite |timespan |boolean test
bool |ishorizontal |line |
bool |ishorizontal |lseg |
bool |ishorizontal |point point |
bool |isoldpath |path |
bool |isopen |path |
bool |isparallel |line line |
bool |isparallel |lseg lseg |
bool |isperpendicular |lseg lseg |
bool |istrue |bool |
bool |isvertical |line |
bool |isvertical |lseg |
bool |isvertical |point point |
bool |keyfirsteq |int2 |
bool |line_eq |line line |lines equal?
bool |line_horizontal |line |lines horizontal?
bool |line_intersect |line line |lines intersect?
bool |line_parallel |line line |lines parallel?
bool |line_perp |line line |lines perpendicular?
bool |line_vertical |line |lines vertical?
bool |lseg_eq |lseg lseg |equal
bool |lseg_ge |lseg lseg |greater-than-or-equal
bool |lseg_gt |lseg lseg |greater-than
bool |lseg_horizontal |lseg |is horizontal
bool |lseg_intersect |lseg lseg |intersects
bool |lseg_le |lseg lseg |less-than-or-equal
bool |lseg_lt |lseg lseg |less-than
bool |lseg_ne |lseg lseg |not equal
bool |lseg_parallel |lseg lseg |is parallel to
bool |lseg_perp |lseg lseg |is perpendicular to
bool |lseg_vertical |lseg |is vertical
bool |macaddr_eq |macaddr macadd|equal
bool |macaddr_ge |macaddr macadd|greater-than-or-equal
bool |macaddr_gt |macaddr macadd|greater-than
bool |macaddr_le |macaddr macadd|less-than-or-equal
bool |macaddr_lt |macaddr macadd|less-than
bool |macaddr_ne |macaddr macadd|not equal
bool |nameeq |name name |equal
bool |namege |name name |greater-than-or-equal
bool |namegt |name name |greater-than
bool |nameicregexeq |name text |matches regex., case-insensitive
bool |nameicregexne |name text |does not match regex., case-insens
bool |namele |name name |less-than-or-equal
bool |namelike |name text |matches LIKE expression
bool |namelt |name name |less-than
bool |namene |name name |not equal
bool |namenlike |name text |does not match LIKE expression
bool |nameregexeq |name text |matches regex., case-sensitive
bool |nameregexne |name text |does not match regex., case-sensit
bool |network_eq |inet inet |equal
bool |network_ge |inet inet |greater-than-or-equal
bool |network_gt |inet inet |greater-than
bool |network_le |inet inet |less-than-or-equal
bool |network_lt |inet inet |less-than
bool |network_ne |inet inet |not equal
bool |network_sub |inet inet |is-subnet
bool |network_subeq |inet inet |is-subnet-or-equal
bool |network_sup |inet inet |is-supernet
bool |network_supeq |inet inet |is-supernet-or-equal
bool |oid8eq |oid8 oid8 |equal
bool |oid8ge |oid8 oid8 |greater-than-or-equal
bool |oid8gt |oid8 oid8 |greater-than
bool |oid8le |oid8 oid8 |less-than-or-equal
bool |oid8lt |oid8 oid8 |less-than
bool |oid8ne |oid8 oid8 |less-than
bool |oideq |oid oid |equal
bool |oideqint4 |oid int4 |equal
bool |oidne |oid oid |not equal
bool |oidnotin |oid |not in
bool |oidrand |oid int4 |random
bool |oidsrand |int4 |seed random number generator
bool |on_pb |point box |point is inside
bool |on_pl |point line |contained in
bool |on_ppath |point path |contained in
bool |on_ps |point lseg |contained in
bool |on_sb |lseg box |contained in
bool |on_sl |lseg line |contained in
bool |path_contain_pt |path point |path contains point?
bool |path_inter |path path |
bool |path_isclosed |path |
bool |path_isopen |path |
bool |path_n_eq |path path |equal
bool |path_n_ge |path path |greater-than-or-equal
bool |path_n_gt |path path |greater-than
bool |path_n_le |path path |less-than-or-equal
bool |path_n_lt |path path |less-than
bool |point_above |point point |is above
bool |point_below |point point |is below
bool |point_eq |point point |same as
bool |point_horiz |point point |is horizontal
bool |point_left |point point |is left of
bool |point_ne |point point |not equal
bool |point_right |point point |is left of
bool |point_vert |point point |is vertical
bool |poly_contain |polygon polygo|contains
bool |poly_contain_pt |polygon point |polygon contains point?
bool |poly_contained |polygon polygo|contained in
bool |poly_left |polygon polygo|is left of
bool |poly_overlap |polygon polygo|overlaps
bool |poly_overleft |polygon polygo|overlaps, but does not extend to r
bool |poly_overright |polygon polygo|overlaps, but does not extend to l
bool |poly_right |polygon polygo|is left of
bool |poly_same |polygon polygo|same as
bool |pt_contained_circle|point circle |
bool |pt_contained_path |point path |point contained in path?
bool |pt_contained_poly |point polygon |point contained by polygon?
bool |reltimeeq |reltime reltim|equal
bool |reltimege |reltime reltim|greater-than-or-equal
bool |reltimegt |reltime reltim|greater-than
bool |reltimele |reltime reltim|less-than-or-equal
bool |reltimelt |reltime reltim|less-than
bool |reltimene |reltime reltim|not equal
bool |smgreq |smgr smgr |storage manager
bool |smgrne |smgr smgr |storage manager
bool |text_ge |text text |greater-than-or-equal
bool |text_gt |text text |greater-than
bool |text_le |text text |less-than-or-equal
bool |text_lt |text text |less-than
bool |texteq |text text |equal
bool |texticregexeq |text text |matches regex., case-insensitive
bool |texticregexne |text text |does not match regex., case-insens
bool |textlike |text text |matches LIKE expression
bool |textne |text text |not equal
bool |textnlike |text text |does not match LIKE expression
bool |textregexeq |text text |matches regex., case-sensitive
bool |textregexne |text text |does not match regex., case-sensit
bool |time_eq |time time |equal
bool |time_ge |time time |greater-than-or-equal
bool |time_gt |time time |greater-than
bool |time_le |time time |less-than-or-equal
bool |time_lt |time time |less-than
bool |time_ne |time time |not equal
bool |timespan_eq |timespan times|equal
bool |timespan_finite |timespan |boolean test
bool |timespan_ge |timespan times|greater-than-or-equal
bool |timespan_gt |timespan times|greater-than
bool |timespan_le |timespan times|less-than-or-equal
bool |timespan_lt |timespan times|less-than
bool |timespan_ne |timespan times|not equal
bool |timestampeq |timestamp time|equal
bool |timestampge |timestamp time|greater-than-or-equal
bool |timestampgt |timestamp time|greater-than
bool |timestample |timestamp time|less-than-or-equal
bool |timestamplt |timestamp time|less-than
bool |timestampne |timestamp time|not equal
bool |varchareq |varchar varcha|equal
bool |varcharge |varchar varcha|greater-than-or-equal
bool |varchargt |varchar varcha|greater-than
bool |varcharle |varchar varcha|less-than-or-equal
bool |varcharlt |varchar varcha|less-than
bool |varcharne |varchar varcha|not equal
bool |xideq |xid xid |equal
box |box |box box |convert
box |box |circle |convert
box |box |point point |convert points to box
box |box |polygon |convert
box |box_add |box point |add point to box (translate)
box |box_div |box point |divide box by point (scale)
box |box_intersect |box box |intersects
box |box_mul |box point |multiply box by point (scale)
box |box_sub |box point |subtract point from box (translate
box |circle_box |circle |convert
box |poly_box |polygon |convert polygon to bounding box
box |rt_box_inter |box box |r-tree
box |rt_box_union |box box |r-tree
bpchar |bpchar |bpchar int4 |
bpchar |bpchar |char |convert to bpchar
bpchar |bpchar |name |convert
bpchar |char_bpchar |char |convert to bpchar
bpchar |name_bpchar |name |convert
bytea |byteaSetBit |bytea int4 int|
bytea |byteaSetByte |bytea int4 int|
bytea |loread |int4 int4 |large object read
char |bpchar_char |bpchar |convert to char
char |chardiv |char char |divide
char |charmi |char char |subtract
char |charmul |char char |multiply
char |charpl |char char |addition
circle |box_circle |box |convert
circle |circle |box |convert
circle |circle |point float8 |convert
circle |circle |polygon |convert
circle |circle_add_pt |circle point |addition
circle |circle_div_pt |circle point |divide
circle |circle_mul_pt |circle point |multiply
circle |circle_sub_pt |circle point |subtract
circle |poly_circle |polygon |convert
date |abstime_date |abstime |convert abstime to date
date |date |abstime |convert
date |date |date |convert
date |date |datetime |convert
date |date_idx2str |text |
date |date_larger |date date |
date |date_mii |date int4 |subtract
date |date_pli |date int4 |addition
date |date_smaller |date date |
date |datetime_date |datetime |convert datetime to date
datetime |abstime_datetime |abstime |convert abstime to datetime
datetime |date_datetime |date |convert date to datetime
datetime |date_trunc |text datetime |truncate datetime to field
datetime |datetime |abstime |convert
datetime |datetime |date |convert
datetime |datetime |date time |convert
datetime |datetime |datetime |convert
datetime |datetime |text |convert
datetime |datetime |timestamp |convert
datetime |datetime_datetime |date time |convert date and time to datetime
datetime |datetime_larger |datetime datet|
datetime |datetime_mi_span |datetime times|minus
datetime |datetime_pl_span |datetime times|plus
datetime |datetime_smaller |datetime datet|
datetime |datetime_trunc |text datetime |truncate datetime to specified uni
datetime |text_datetime |text |convert
datetime |timestamp_datetime |timestamp |convert timestamp to datetime
float4 |dtof |float8 |convert
float4 |float4 |float4 |convert float4 to float4 (no-op)
float4 |float4 |float8 |convert float8 to float4
float4 |float4 |int2 |convert int2 to float4
float4 |float4 |int4 |convert int4 to float4
float4 |float4abs |float4 float4 |absolute value
float4 |float4div |float4 float4 |divide
float4 |float4inc |float4 |
float4 |float4larger |float4 float4 |
float4 |float4mi |float4 float4 |subtract
float4 |float4mul |float4 float4 |multiply
float4 |float4pl |float4 float4 |addition
float4 |float4smaller |float4 float4 |
float4 |float4um |float4 |subtract
float4 |i2tof |int2 |convert
float4 |i4tof |int4 |convert
float4 |rt_bigbox_size |box float4 |r-tree
float4 |rt_box_size |box float4 |r-tree
float8 |area |box |
float8 |area |circle |
float8 |areajoinsel |oid oid int2 i|selectivity
float8 |areasel |oid oid int2 i|selectivity
float8 |box_area |box |box area
float8 |box_distance |box box |distance between
float8 |box_height |box |box height
float8 |box_width |box |box width
float8 |btreenpage |oid oid int2 i|btree
float8 |btreesel |oid oid int2 i|btree selectivity
float8 |circle_area |circle |area
float8 |circle_diameter |circle |diameter
float8 |circle_distance |circle circle |distance between
float8 |circle_radius |circle |radius
float8 |date_part |text abstime |extract field from abstime
float8 |date_part |text date |extract field from date
float8 |date_part |text datetime |extract field from datetime
float8 |date_part |text reltime |extract field from reltime
float8 |date_part |text time |extract field from time
float8 |date_part |text timespan |extract field from timespan
float8 |datetime_part |text datetime |extract field from datetime
float8 |dcbrt |float8 |cube root
float8 |dexp |float8 |exponential
float8 |diameter |circle |
float8 |dist_cpoly |circle polygon|distance between
float8 |dist_lb |line box |distance between
float8 |dist_pb |point box |distance between
float8 |dist_pl |point line |distance between
float8 |dist_ppath |point path |distance between
float8 |dist_ps |point lseg |distance between
float8 |dist_sb |lseg box |distance between
float8 |dist_sl |lseg line |distance between
float8 |dlog1 |float8 |natural logarithm (in psql, protec
float8 |dpow |float8 float8 |exponentiation
float8 |dround |float8 |truncate to integer
float8 |dsqrt |float8 |square root
float8 |dtrunc |float8 |truncate to integer
float8 |eqjoinsel |oid oid int2 o|selectivity
float8 |eqsel |oid oid int2 i|general selectivity
float8 |float |float4 |convert float4 to float8
float8 |float |float8 |convert float8 to float8 (no-op)
float8 |float48div |float4 float8 |divide
float8 |float48mi |float4 float8 |subtract
float8 |float48mul |float4 float8 |multiply
float8 |float48pl |float4 float8 |addition
float8 |float8 |float4 |convert float4 to float8
float8 |float8 |float8 |convert float8 to float8 (no-op)
float8 |float8 |int2 |convert int2 to float8
float8 |float8 |int4 |convert int4 to float8
float8 |float8 |int8 |convert int8 to float8
float8 |float84div |float8 float4 |divide
float8 |float84mi |float8 float4 |subtract
float8 |float84mul |float8 float4 |multiply
float8 |float84pl |float8 float4 |addition
float8 |float8abs |float8 |absolute value
float8 |float8div |float8 float8 |divide
float8 |float8inc |float8 |
float8 |float8larger |float8 float8 |
float8 |float8mi |float8 float8 |subtract
float8 |float8mul |float8 float8 |multiply
float8 |float8pl |float8 float8 |addition
float8 |float8smaller |float8 float8 |
float8 |float8um |float8 |subtract
float8 |ftod |float4 |convert
float8 |gistnpage |oid oid int2 i|gist
float8 |gistsel |oid oid int2 i|gist selectivity
float8 |hashnpage |oid oid int2 i|hash
float8 |hashsel |oid oid int2 i|selectivity
float8 |height |box |
float8 |i2tod |int2 |convert
float8 |i4tod |int4 |convert
float8 |i8tod |int8 |convert int8 to float8
float8 |intgtjoinsel |oid oid int2 o|selectivity
float8 |intgtsel |oid oid int2 i|selectivity
float8 |intltjoinsel |oid oid int2 o|selectivity
float8 |intltsel |oid oid int2 i|selectivity
float8 |length |lseg |distance between endpoints
float8 |length |path |sum of lengths of path segments
float8 |line_distance |line line |distance between
float8 |lseg_distance |lseg lseg |distance between
float8 |lseg_length |lseg |distance between endpoints
float8 |neqjoinsel |oid oid int2 o|selectivity
float8 |neqsel |oid oid int2 i|not-equal selectivity
float8 |path_distance |path path |distance between
float8 |path_length |path |sum of path segments
float8 |point_distance |point point |distance between
float8 |point_slope |point point |slope between points
float8 |poly_distance |polygon polygo|distance between
float8 |radius |circle |
float8 |rtnpage |oid oid int2 i|r-tree
float8 |rtsel |oid oid int2 i|r-tree
float8 |slope |point point |
float8 |timespan_part |text timespan |extract field from timespan
float8 |width |box |
int2 |dtoi2 |float8 |convert
int2 |ftoi2 |float4 |convert
int2 |i4toi2 |int4 |convert
int2 |int2 |float4 |convert float4 to int2
int2 |int2 |float8 |convert float8 to int2
int2 |int2 |int2 |convert int2 to int2 (no-op)
int2 |int2 |int4 |convert int4 to int2
int2 |int2 |text |convert
int2 |int2div |int2 int2 |divide
int2 |int2fac |int2 |
int2 |int2inc |int2 |
int2 |int2larger |int2 int2 |larger of two
int2 |int2mi |int2 int2 |subtract
int2 |int2mod |int2 int2 |modulus
int2 |int2mul |int2 int2 |multiply
int2 |int2pl |int2 int2 |addition
int2 |int2smaller |int2 int2 |smaller of two
int2 |int2um |int2 |subtract
int2 |text_int2 |text |convert
int4 |array_assgn |int4 int4 int4|array
int4 |array_clip |int4 int4 int4|array
int4 |array_ref |int4 int4 int4|array
int4 |array_set |int4 int4 int4|array
int4 |bpcharcmp |bpchar bpchar |less-equal-greater
int4 |bpcharlen |bpchar |octet length
int4 |bpcharoctetlen |bpchar |octet length
int4 |btabstimecmp |abstime abstim|btree less-equal-greater
int4 |btcharcmp |char char |btree less-equal-greater
int4 |btfloat4cmp |float4 float4 |btree less-equal-greater
int4 |btfloat8cmp |float8 float8 |btree less-equal-greater
int4 |btint24cmp |int2 int4 |btree less-equal-greater
int4 |btint2cmp |int2 int2 |btree less-equal-greater
int4 |btint42cmp |int4 int2 |btree less-equal-greater
int4 |btint4cmp |int4 int4 |btree less-equal-greater
int4 |btnamecmp |name name |btree less-equal-greater
int4 |btoid8cmp |oid8 oid8 |btree less-equal-greater
int4 |btoidcmp |oid oid |btree less-equal-greater
int4 |bttextcmp |text text |btree less-equal-greater
int4 |byteaGetBit |bytea int4 |
int4 |byteaGetByte |bytea int4 |
int4 |byteaGetSize |bytea |
int4 |char |bpchar |convert to char
int4 |currval |text |sequence current value
int4 |date_cmp |date date |less-equal-greater
int4 |date_mi |date date |subtract
int4 |datetime_cmp |datetime datet|less-equal-greater
int4 |dtoi4 |float8 |convert
int4 |ftoi4 |float4 |convert
int4 |hashbpchar |bpchar |hash
int4 |hashchar |char char |hash
int4 |hashfloat4 |float4 float4 |hash
int4 |hashfloat8 |float8 float8 |hash
int4 |hashint2 |int2 int2 |hash
int4 |hashint4 |int4 int4 |hash
int4 |hashname |name name |hash
int4 |hashoid |oid oid |hash
int4 |hashoid8 |oid8 oid8 |hash
int4 |hashtext |text text |hash
int4 |hashvarchar |varchar |hash
int4 |i2toi4 |int2 |convert
int4 |int |int4 |convert int4 to int4 (no-op)
int4 |int24div |int2 int4 |divide
int4 |int24eq |int2 int4 |equal
int4 |int24ge |int2 int4 |greater-than-or-equal
int4 |int24gt |int2 int4 |greater-than
int4 |int24le |int2 int4 |less-than-or-equal
int4 |int24lt |int2 int4 |less-than
int4 |int24mi |int2 int4 |subtract
int4 |int24mod |int2 int4 |modulus
int4 |int24mul |int2 int4 |multiply
int4 |int24ne |int2 int4 |not equal
int4 |int24pl |int2 int4 |addition
int4 |int4 |float4 |convert float4 to int4
int4 |int4 |float8 |convert float8 to int4
int4 |int4 |int2 |convert int2 to int4
int4 |int4 |int4 |convert int4 to int4 (no-op)
int4 |int4 |int8 |convert int8 to int4
int4 |int4 |text |convert
int4 |int42div |int4 int2 |divide
int4 |int42eq |int4 int2 |equal
int4 |int42ge |int4 int2 |greater-than-or-equal
int4 |int42gt |int4 int2 |greater-than
int4 |int42le |int4 int2 |less-than-or-equal
int4 |int42lt |int4 int2 |less-than
int4 |int42mi |int4 int2 |subtract
int4 |int42mod |int4 int2 |modulus
int4 |int42mul |int4 int2 |multiply
int4 |int42ne |int4 int2 |not equal
int4 |int42pl |int4 int2 |addition
int4 |int4div |int4 int4 |divide
int4 |int4fac |int4 |fraction
int4 |int4inc |int4 |
int4 |int4larger |int4 int4 |larger of two
int4 |int4mi |int4 int4 |subtract
int4 |int4mod |int4 int4 |modulus
int4 |int4mul |int4 int4 |multiply
int4 |int4pl |int4 int4 |addition
int4 |int4smaller |int4 int4 |smaller of two
int4 |int4um |int4 |subtract
int4 |int84 |int8 |convert int8 to int4
int4 |length |bpchar |character length
int4 |length |text |character length
int4 |length |varchar |character length
int4 |lo_close |int4 |large object close
int4 |lo_export |oid text |large object export
int4 |lo_lseek |int4 int4 int4|large object seek
int4 |lo_open |oid int4 |large object open
int4 |lo_tell |int4 |large object position
int4 |lo_unlink |oid |large object unlink(delete)
int4 |lowrite |int4 bytea |large object write
int4 |macaddr_cmp |macaddr macadd|less-equal-greater
int4 |masklen |inet |netmask length
int4 |network_cmp |inet inet |less-equal-greater
int4 |network_masklen |inet |netmask length
int4 |nextval |text |sequence next value
int4 |octet_length |bpchar |octet length
int4 |octet_length |text |octet length
int4 |octet_length |varchar |octet length
int4 |path_npoints |path |
int4 |pointdist |point point |
int4 |points |path |
int4 |points |polygon |
int4 |poly_npoints |polygon |number of points in polygon
int4 |pqtest |text |
int4 |rt_poly_size |polygon int4 |r-tree
int4 |seteval |oid |
int4 |setval |text int4 |sequence set value
int4 |strpos |text text |find position of substring
int4 |text_int4 |text |convert
int4 |textlen |text |length
int4 |textoctetlen |text |octet length
int4 |textpos |text text |return position of substring
int4 |time_cmp |time time |less-equal-greater
int4 |timespan_cmp |timespan times|less-equal-greater
int4 |userfntest |int4 |
int4 |varcharcmp |varchar varcha|less-equal-greater
int4 |varcharlen |varchar |character length
int4 |varcharoctetlen |varchar |octet length
int8 |dtoi8 |float8 |convert float8 to int8
int8 |int48 |int4 |convert int4 to int8
int8 |int48div |int4 int8 |divide
int8 |int48mi |int4 int8 |subtraction
int8 |int48mul |int4 int8 |multiply
int8 |int48pl |int4 int8 |addition
int8 |int8 |float8 |convert float8 to int8
int8 |int8 |int4 |convert int4 to int8
int8 |int8 |int8 |convert int8 to int8 (no-op)
int8 |int84div |int8 int4 |divide
int8 |int84mi |int8 int4 |subtraction
int8 |int84mul |int8 int4 |multiply
int8 |int84pl |int8 int4 |addition
int8 |int8div |int8 int8 |divide
int8 |int8larger |int8 int8 |larger of two
int8 |int8mi |int8 int8 |subtraction
int8 |int8mul |int8 int8 |multiply
int8 |int8pl |int8 int8 |addition
int8 |int8smaller |int8 int8 |smaller of two
int8 |int8um |int8 |unary minus
line |line |point point |
line |line_construct_pp |point point |line from points
lseg |box_diagonal |box |box diagonal
lseg |lseg |box |
lseg |lseg |point point |
lseg |lseg_construct |point point |convert points to line segment
money |cash_div_flt4 |money float4 |divide
money |cash_div_flt8 |money float8 |divide
money |cash_div_int2 |money int2 |divide
money |cash_div_int4 |money int4 |divide
money |cash_mi |money money |subtract
money |cash_mul_flt4 |money float4 |multiply
money |cash_mul_flt8 |money float8 |multiply
money |cash_mul_int2 |money int2 |multiply
money |cash_mul_int4 |money int4 |multiply
money |cash_pl |money money |addition
money |cashlarger |money money |
money |cashsmaller |money money |
money |flt4_mul_cash |float4 money |multiply
money |flt8_mul_cash |float8 money |multiply
money |int2_mul_cash |int2 money |multiply
money |int4_mul_cash |int4 money |multiply
name |bpchar_name |bpchar |convert
name |getdatabaseencoding| |
name |getpgusername | |(internal)
name |name |bpchar |convert
name |name |text |convert
name |name |varchar |convert
name |pg_get_userbyid |int4 |user name by UID (with fallback)
name |text_name |text |convert
oid |lo_creat |int4 |large object create
oid |lo_import |text |large object import
oid |oid |text |convert
oid |regproctooid |regproc |get oid for regproc
oid |text_oid |text |convert
path |path |polygon |
path |path_add |path path |addition
path |path_add_pt |path point |addition
path |path_close |path |
path |path_div_pt |path point |divide
path |path_mul_pt |path point |multiply
path |path_open |path |
path |path_sub_pt |path point |subtract
path |pclose |path |
path |poly_path |polygon |convert polygon to path
path |popen |path |
path |upgradepath |path |
point |box_center |box |center of
point |center |box |
point |center |circle |
point |center |polygon |
point |circle_center |circle |center of
point |close_lb |line box |closest point to line on box
point |close_ls |line lseg |closest point to line on line segm
point |close_lseg |lseg lseg |closest point to line segment on l
point |close_pb |point box |closest point on box
point |close_pl |point line |closest point on line
point |close_ps |point lseg |closest point on line segment
point |close_sb |lseg box |closest point to line segment on b
point |close_sl |lseg line |closest point to line segment on l
point |line_interpt |line line |intersection point
point |lseg_center |lseg |center of
point |lseg_interpt |lseg lseg |
point |path_center |path |center of
point |point |circle |convert
point |point |float8 float8 |convert x, y to point
point |point |lseg lseg |convert
point |point_add |point point |add points (translate)
point |point_div |point point |divide points (scale/rotate)
point |point_mul |point point |multiply points (scale/rotate)
point |point_sub |point point |subtract points (translate)
point |poly_center |polygon |center of
polygon |box_poly |box |convert box to polygon
polygon |circle_poly |int4 circle |convert
polygon |dist_pc |point circle |distance between
polygon |path_poly |path |convert path to polygon
polygon |polygon |box |convert
polygon |polygon |circle |convert
polygon |polygon |int4 circle |convert
polygon |polygon |path |convert
polygon |revertpoly |polygon |
polygon |rt_poly_inter |polygon polygo|r-tree
polygon |rt_poly_union |polygon polygo|r-tree
polygon |upgradepoly |polygon |
reltime |int4reltime |int4 |convert
reltime |intervalrel |tinterval |
reltime |reltime |reltime |convert
reltime |reltime |timespan |convert
reltime |timespan_reltime |timespan |convert
text |broadcast |inet |broadcast address
text |btrim |text |trim both ends of string
text |btrim |text text |trim both ends of string
text |cash_words_out |money |output amount as words
text |date_zone |text datetime |
text |datetime_text |datetime |convert
text |datetime_zone |text datetime |
text |host |inet |host address
text |initcap |text |capitalize each word
text |int2_text |int2 |convert
text |int4_text |int4 |convert
text |lower |text |lowercase
text |lpad |text int4 |left-pad string to length
text |lpad |text int4 text|left-pad string to length
text |ltrim |text |remove initial characters from str
text |ltrim |text text |left-pad string to length
text |macaddr_manuf |macaddr |MAC manufacturer
text |name_text |name |convert
text |netmask |inet |netmask of address
text |network |inet |network address
text |network_broadcast |inet |broadcast address
text |network_host |inet |host address
text |network_netmask |inet |netmask of address
text |network_network |inet |network address
text |obj_description |oid |get description for object id
text |oid8types |oid8 |print type names of oid8 field
text |oid_text |oid |convert
text |pg_get_indexdef |oid |index description
text |pg_get_ruledef |name |source text of a rule
text |pg_get_viewdef |name |select statement of a view
text |rpad |text int4 |right-pad string to length
text |rpad |text int4 text|right-pad string to length
text |rtrim |text |remove trailing characters from st
text |rtrim |text text |right-pad string to length
text |substr |text int4 |return portion of string
text |substr |text int4 int4|return portion of string
text |text |datetime |convert
text |text |int2 |convert
text |text |int4 |convert
text |text |name |convert
text |text |oid |convert
text |text |timespan |convert
text |text_substr |text int4 int4|return portion of string
text |textcat |text text |concatenate
text |timeofday | |(internal)
text |timespan_text |timespan |convert
text |translate |text char char|modify string by substring replace
text |upper |text |uppercase
text |version | |PostgreSQL version string
time |datetime_time |datetime |convert
time |time |abstime |convert
time |time |datetime |convert
time |time |time |convert
timespan |age |datetime |difference between datetime and to
timespan |age |datetime datet|difference between datetimes but l
timespan |date_trunc |text timespan |truncate timespan to field
timespan |datetime_age |datetime datet|date difference preserving months
timespan |datetime_mi |datetime datet|subtract
timespan |reltime_timespan |reltime |convert reltime to timespan
timespan |text_timespan |text |convert
timespan |timespan |reltime |convert
timespan |timespan |text |convert
timespan |timespan |time |convert
timespan |timespan |timespan |convert
timespan |timespan_div |timespan float|divide
timespan |timespan_larger |timespan times|
timespan |timespan_mi |timespan times|subtract
timespan |timespan_pl |timespan times|addition
timespan |timespan_smaller |timespan times|
timespan |timespan_trunc |text timespan |truncate timespan to specified uni
timespan |timespan_um |timespan |subtract
timestamp|datetime_timestamp |datetime |convert
timestamp|now | |current transaction time
timestamp|timestamp |datetime |convert
timestamp|timestamp |timestamp |convert
tinterval|mktinterval |abstime abstim|convert to interval
varchar |varchar |name |convert
varchar |varchar |varchar int4 |
(816 rows)
---------+-------------------+--------------+----------------------------------
_aclitem |aclinsert |_aclitem aclit|addition
_aclitem |aclremove |_aclitem aclit|subtract
abstime |abstime |abstime |convert
abstime |abstime |datetime |convert
abstime |datetime_abstime |datetime |convert datetime to abstime
abstime |intervalend |tinterval |
abstime |intervalstart |tinterval |start of interval
abstime |timemi |abstime reltim|subtract
abstime |timenow | |(internal)
abstime |timepl |abstime reltim|addition
bool |abstime_finite |abstime |
bool |abstimeeq |abstime abstim|equal
bool |abstimege |abstime abstim|greater-than-or-equal
bool |abstimegt |abstime abstim|greater-than
bool |abstimele |abstime abstim|less-than-or-equal
bool |abstimelt |abstime abstim|less-than
bool |abstimene |abstime abstim|not equal
bool |aclcontains |_aclitem aclit|matches regex., case-sensitive
bool |booleq |bool bool |equal
bool |boolgt |bool bool |greater-than
bool |boollt |bool bool |less-than
bool |boolne |bool bool |not equal
bool |box_above |box box |is above
bool |box_below |box box |is below
bool |box_contain |box box |contains
bool |box_contained |box box |contained in
bool |box_eq |box box |equal
bool |box_ge |box box |greater-than-or-equal
bool |box_gt |box box |greater-than
bool |box_le |box box |less-than-or-equal
bool |box_left |box box |is left of
bool |box_lt |box box |less-than
bool |box_overlap |box box |overlaps
bool |box_overleft |box box |overlaps, but does not extend to r
bool |box_overright |box box |overlaps, but does not extend to l
bool |box_right |box box |is left of
bool |box_same |box box |same as
bool |bpchareq |bpchar bpchar |equal
bool |bpcharge |bpchar bpchar |greater-than-or-equal
bool |bpchargt |bpchar bpchar |greater-than
bool |bpcharle |bpchar bpchar |less-than-or-equal
bool |bpcharlt |bpchar bpchar |less-than
bool |bpcharne |bpchar bpchar |not equal
bool |cash_eq |money money |equal
bool |cash_ge |money money |greater-than-or-equal
bool |cash_gt |money money |greater-than
bool |cash_le |money money |less-than-or-equal
bool |cash_lt |money money |less-than
bool |cash_ne |money money |not equal
bool |chareq |char char |equal
bool |charge |char char |greater-than-or-equal
bool |chargt |char char |greater-than
bool |charle |char char |less-than-or-equal
bool |charlt |char char |less-than
bool |charne |char char |not equal
bool |cideq |cid cid |equal
bool |circle_above |circle circle |is above
bool |circle_below |circle circle |is below
bool |circle_contain |circle circle |contains
bool |circle_contain_pt |circle point |
bool |circle_contained |circle circle |
bool |circle_eq |circle circle |equal
bool |circle_ge |circle circle |greater-than-or-equal
bool |circle_gt |circle circle |greater-than
bool |circle_le |circle circle |less-than-or-equal
bool |circle_left |circle circle |is left of
bool |circle_lt |circle circle |less-than
bool |circle_ne |circle circle |not equal
bool |circle_overlap |circle circle |overlaps
bool |circle_overleft |circle circle |overlaps, but does not extend to r
bool |circle_overright |circle circle |
bool |circle_right |circle circle |is left of
bool |circle_same |circle circle |same as
bool |date_eq |date date |equal
bool |date_ge |date date |greater-than-or-equal
bool |date_gt |date date |greater-than
bool |date_le |date date |less-than-or-equal
bool |date_lt |date date |less-than
bool |date_ne |date date |not equal
bool |datetime_eq |datetime datet|equal
bool |datetime_finite |datetime |
bool |datetime_ge |datetime datet|greater-than-or-equal
bool |datetime_gt |datetime datet|greater-than
bool |datetime_le |datetime datet|less-than-or-equal
bool |datetime_lt |datetime datet|less-than
bool |datetime_ne |datetime datet|not equal
bool |float48eq |float4 float8 |equal
bool |float48ge |float4 float8 |greater-than-or-equal
bool |float48gt |float4 float8 |greater-than
bool |float48le |float4 float8 |less-than-or-equal
bool |float48lt |float4 float8 |less-than
bool |float48ne |float4 float8 |not equal
bool |float4eq |float4 float4 |equal
bool |float4ge |float4 float4 |greater-than-or-equal
bool |float4gt |float4 float4 |greater-than
bool |float4le |float4 float4 |less-than-or-equal
bool |float4lt |float4 float4 |less-than
bool |float4ne |float4 float4 |not equal
bool |float84eq |float8 float4 |equal
bool |float84ge |float8 float4 |greater-than-or-equal
bool |float84gt |float8 float4 |greater-than
bool |float84le |float8 float4 |less-than-or-equal
bool |float84lt |float8 float4 |less-than
bool |float84ne |float8 float4 |not equal
bool |float8eq |float8 float8 |equal
bool |float8ge |float8 float8 |greater-than-or-equal
bool |float8gt |float8 float8 |greater-than
bool |float8le |float8 float8 |less-than-or-equal
bool |float8lt |float8 float8 |less-than
bool |float8ne |float8 float8 |not equal
bool |ininterval |abstime tinter|abstime in tinterval
bool |int2eq |int2 int2 |equal
bool |int2ge |int2 int2 |greater-than-or-equal
bool |int2gt |int2 int2 |greater-than
bool |int2le |int2 int2 |less-than-or-equal
bool |int2lt |int2 int2 |less-than
bool |int2ne |int2 int2 |not equal
bool |int48eq |int2 int8 |equal
bool |int48ge |int2 int8 |greater-than-or-equal
bool |int48gt |int2 int8 |greater-than
bool |int48le |int2 int8 |less-than-or-equal
bool |int48lt |int2 int8 |less-than
bool |int48ne |int2 int8 |not equal
bool |int4eq |int4 int4 |equal
bool |int4eqoid |int4 oid |equal
bool |int4ge |int4 int4 |greater-than-or-equal
bool |int4gt |int4 int4 |greater-than
bool |int4le |int4 int4 |less-than-or-equal
bool |int4lt |int4 int4 |less-than
bool |int4ne |int4 int4 |not equal
bool |int4notin |int2 |not in
bool |int84eq |int8 int4 |equal
bool |int84ge |int8 int4 |greater-than-or-equal
bool |int84gt |int8 int4 |greater-than
bool |int84le |int8 int4 |less-than-or-equal
bool |int84lt |int8 int4 |less-than
bool |int84ne |int8 int4 |not equal
bool |int8eq |int8 int8 |equal
bool |int8ge |int8 int8 |greater-than-or-equal
bool |int8gt |int8 int8 |greater-than
bool |int8le |int8 int8 |less-than-or-equal
bool |int8lt |int8 int8 |less-than
bool |int8ne |int8 int8 |not equal
bool |inter_lb |line box |
bool |inter_sb |lseg box |
bool |inter_sl |lseg line |
bool |intervalct |tinterval tint|less-than
bool |intervaleq |tinterval tint|equal
bool |intervalge |tinterval tint|greater-than-or-equal
bool |intervalgt |tinterval tint|greater-than
bool |intervalle |tinterval tint|less-than-or-equal
bool |intervalleneq |tinterval relt|length equal
bool |intervallenge |tinterval relt|length greater-than-or-equal
bool |intervallengt |tinterval relt|length greater-than
bool |intervallenle |tinterval relt|length less-than-or-equal
bool |intervallenlt |tinterval relt|length less-than
bool |intervallenne |tinterval relt|length not equal to
bool |intervallt |tinterval tint|less-than
bool |intervalne |tinterval tint|not equal
bool |intervalov |tinterval tint|overlaps
bool |intervalsame |tinterval tint|same as
bool |isclosed |path |
bool |isfalse |bool |
bool |isfinite |abstime |boolean test
bool |isfinite |datetime |boolean test
bool |isfinite |timespan |boolean test
bool |ishorizontal |line |
bool |ishorizontal |lseg |
bool |ishorizontal |point point |
bool |isoldpath |path |
bool |isopen |path |
bool |isparallel |line line |
bool |isparallel |lseg lseg |
bool |isperpendicular |lseg lseg |
bool |istrue |bool |
bool |isvertical |line |
bool |isvertical |lseg |
bool |isvertical |point point |
bool |keyfirsteq |int2 |
bool |line_eq |line line |lines equal?
bool |line_horizontal |line |lines horizontal?
bool |line_intersect |line line |lines intersect?
bool |line_parallel |line line |lines parallel?
bool |line_perp |line line |lines perpendicular?
bool |line_vertical |line |lines vertical?
bool |lseg_eq |lseg lseg |equal
bool |lseg_ge |lseg lseg |greater-than-or-equal
bool |lseg_gt |lseg lseg |greater-than
bool |lseg_horizontal |lseg |is horizontal
bool |lseg_intersect |lseg lseg |intersects
bool |lseg_le |lseg lseg |less-than-or-equal
bool |lseg_lt |lseg lseg |less-than
bool |lseg_ne |lseg lseg |not equal
bool |lseg_parallel |lseg lseg |is parallel to
bool |lseg_perp |lseg lseg |is perpendicular to
bool |lseg_vertical |lseg |is vertical
bool |macaddr_eq |macaddr macadd|equal
bool |macaddr_ge |macaddr macadd|greater-than-or-equal
bool |macaddr_gt |macaddr macadd|greater-than
bool |macaddr_le |macaddr macadd|less-than-or-equal
bool |macaddr_lt |macaddr macadd|less-than
bool |macaddr_ne |macaddr macadd|not equal
bool |nameeq |name name |equal
bool |namege |name name |greater-than-or-equal
bool |namegt |name name |greater-than
bool |nameicregexeq |name text |matches regex., case-insensitive
bool |nameicregexne |name text |does not match regex., case-insens
bool |namele |name name |less-than-or-equal
bool |namelike |name text |matches LIKE expression
bool |namelt |name name |less-than
bool |namene |name name |not equal
bool |namenlike |name text |does not match LIKE expression
bool |nameregexeq |name text |matches regex., case-sensitive
bool |nameregexne |name text |does not match regex., case-sensit
bool |network_eq |inet inet |equal
bool |network_ge |inet inet |greater-than-or-equal
bool |network_gt |inet inet |greater-than
bool |network_le |inet inet |less-than-or-equal
bool |network_lt |inet inet |less-than
bool |network_ne |inet inet |not equal
bool |network_sub |inet inet |is-subnet
bool |network_subeq |inet inet |is-subnet-or-equal
bool |network_sup |inet inet |is-supernet
bool |network_supeq |inet inet |is-supernet-or-equal
bool |oid8eq |oid8 oid8 |equal
bool |oid8ge |oid8 oid8 |greater-than-or-equal
bool |oid8gt |oid8 oid8 |greater-than
bool |oid8le |oid8 oid8 |less-than-or-equal
bool |oid8lt |oid8 oid8 |less-than
bool |oid8ne |oid8 oid8 |less-than
bool |oideq |oid oid |equal
bool |oideqint4 |oid int4 |equal
bool |oidne |oid oid |not equal
bool |oidnotin |oid |not in
bool |oidrand |oid int4 |random
bool |oidsrand |int4 |seed random number generator
bool |on_pb |point box |point is inside
bool |on_pl |point line |contained in
bool |on_ppath |point path |contained in
bool |on_ps |point lseg |contained in
bool |on_sb |lseg box |contained in
bool |on_sl |lseg line |contained in
bool |path_contain_pt |path point |path contains point?
bool |path_inter |path path |
bool |path_isclosed |path |
bool |path_isopen |path |
bool |path_n_eq |path path |equal
bool |path_n_ge |path path |greater-than-or-equal
bool |path_n_gt |path path |greater-than
bool |path_n_le |path path |less-than-or-equal
bool |path_n_lt |path path |less-than
bool |point_above |point point |is above
bool |point_below |point point |is below
bool |point_eq |point point |same as
bool |point_horiz |point point |is horizontal
bool |point_left |point point |is left of
bool |point_ne |point point |not equal
bool |point_right |point point |is left of
bool |point_vert |point point |is vertical
bool |poly_contain |polygon polygo|contains
bool |poly_contain_pt |polygon point |polygon contains point?
bool |poly_contained |polygon polygo|contained in
bool |poly_left |polygon polygo|is left of
bool |poly_overlap |polygon polygo|overlaps
bool |poly_overleft |polygon polygo|overlaps, but does not extend to r
bool |poly_overright |polygon polygo|overlaps, but does not extend to l
bool |poly_right |polygon polygo|is left of
bool |poly_same |polygon polygo|same as
bool |pt_contained_circle|point circle |
bool |pt_contained_path |point path |point contained in path?
bool |pt_contained_poly |point polygon |point contained by polygon?
bool |reltimeeq |reltime reltim|equal
bool |reltimege |reltime reltim|greater-than-or-equal
bool |reltimegt |reltime reltim|greater-than
bool |reltimele |reltime reltim|less-than-or-equal
bool |reltimelt |reltime reltim|less-than
bool |reltimene |reltime reltim|not equal
bool |smgreq |smgr smgr |storage manager
bool |smgrne |smgr smgr |storage manager
bool |text_ge |text text |greater-than-or-equal
bool |text_gt |text text |greater-than
bool |text_le |text text |less-than-or-equal
bool |text_lt |text text |less-than
bool |texteq |text text |equal
bool |texticregexeq |text text |matches regex., case-insensitive
bool |texticregexne |text text |does not match regex., case-insens
bool |textlike |text text |matches LIKE expression
bool |textne |text text |not equal
bool |textnlike |text text |does not match LIKE expression
bool |textregexeq |text text |matches regex., case-sensitive
bool |textregexne |text text |does not match regex., case-sensit
bool |time_eq |time time |equal
bool |time_ge |time time |greater-than-or-equal
bool |time_gt |time time |greater-than
bool |time_le |time time |less-than-or-equal
bool |time_lt |time time |less-than
bool |time_ne |time time |not equal
bool |timespan_eq |timespan times|equal
bool |timespan_finite |timespan |boolean test
bool |timespan_ge |timespan times|greater-than-or-equal
bool |timespan_gt |timespan times|greater-than
bool |timespan_le |timespan times|less-than-or-equal
bool |timespan_lt |timespan times|less-than
bool |timespan_ne |timespan times|not equal
bool |timestampeq |timestamp time|equal
bool |timestampge |timestamp time|greater-than-or-equal
bool |timestampgt |timestamp time|greater-than
bool |timestample |timestamp time|less-than-or-equal
bool |timestamplt |timestamp time|less-than
bool |timestampne |timestamp time|not equal
bool |varchareq |varchar varcha|equal
bool |varcharge |varchar varcha|greater-than-or-equal
bool |varchargt |varchar varcha|greater-than
bool |varcharle |varchar varcha|less-than-or-equal
bool |varcharlt |varchar varcha|less-than
bool |varcharne |varchar varcha|not equal
bool |xideq |xid xid |equal
box |box |box box |convert
box |box |circle |convert
box |box |point point |convert points to box
box |box |polygon |convert
box |box_add |box point |add point to box (translate)
box |box_div |box point |divide box by point (scale)
box |box_intersect |box box |intersects
box |box_mul |box point |multiply box by point (scale)
box |box_sub |box point |subtract point from box (translate
box |circle_box |circle |convert
box |poly_box |polygon |convert polygon to bounding box
box |rt_box_inter |box box |r-tree
box |rt_box_union |box box |r-tree
bpchar |bpchar |bpchar int4 |
bpchar |bpchar |char |convert to bpchar
bpchar |bpchar |name |convert
bpchar |char_bpchar |char |convert to bpchar
bpchar |name_bpchar |name |convert
bytea |byteaSetBit |bytea int4 int|
bytea |byteaSetByte |bytea int4 int|
bytea |loread |int4 int4 |large object read
char |bpchar_char |bpchar |convert to char
char |chardiv |char char |divide
char |charmi |char char |subtract
char |charmul |char char |multiply
char |charpl |char char |addition
circle |box_circle |box |convert
circle |circle |box |convert
circle |circle |point float8 |convert
circle |circle |polygon |convert
circle |circle_add_pt |circle point |addition
circle |circle_div_pt |circle point |divide
circle |circle_mul_pt |circle point |multiply
circle |circle_sub_pt |circle point |subtract
circle |poly_circle |polygon |convert
date |abstime_date |abstime |convert abstime to date
date |date |abstime |convert
date |date |date |convert
date |date |datetime |convert
date |date_idx2str |text |
date |date_larger |date date |
date |date_mii |date int4 |subtract
date |date_pli |date int4 |addition
date |date_smaller |date date |
date |datetime_date |datetime |convert datetime to date
datetime |abstime_datetime |abstime |convert abstime to datetime
datetime |date_datetime |date |convert date to datetime
datetime |date_trunc |text datetime |truncate datetime to field
datetime |datetime |abstime |convert
datetime |datetime |date |convert
datetime |datetime |date time |convert
datetime |datetime |datetime |convert
datetime |datetime |text |convert
datetime |datetime |timestamp |convert
datetime |datetime_datetime |date time |convert date and time to datetime
datetime |datetime_larger |datetime datet|
datetime |datetime_mi_span |datetime times|minus
datetime |datetime_pl_span |datetime times|plus
datetime |datetime_smaller |datetime datet|
datetime |datetime_trunc |text datetime |truncate datetime to specified uni
datetime |text_datetime |text |convert
datetime |timestamp_datetime |timestamp |convert timestamp to datetime
float4 |dtof |float8 |convert
float4 |float4 |float4 |convert float4 to float4 (no-op)
float4 |float4 |float8 |convert float8 to float4
float4 |float4 |int2 |convert int2 to float4
float4 |float4 |int4 |convert int4 to float4
float4 |float4abs |float4 float4 |absolute value
float4 |float4div |float4 float4 |divide
float4 |float4inc |float4 |
float4 |float4larger |float4 float4 |
float4 |float4mi |float4 float4 |subtract
float4 |float4mul |float4 float4 |multiply
float4 |float4pl |float4 float4 |addition
float4 |float4smaller |float4 float4 |
float4 |float4um |float4 |subtract
float4 |i2tof |int2 |convert
float4 |i4tof |int4 |convert
float4 |rt_bigbox_size |box float4 |r-tree
float4 |rt_box_size |box float4 |r-tree
float8 |area |box |
float8 |area |circle |
float8 |areajoinsel |oid oid int2 i|selectivity
float8 |areasel |oid oid int2 i|selectivity
float8 |box_area |box |box area
float8 |box_distance |box box |distance between
float8 |box_height |box |box height
float8 |box_width |box |box width
float8 |btreenpage |oid oid int2 i|btree
float8 |btreesel |oid oid int2 i|btree selectivity
float8 |circle_area |circle |area
float8 |circle_diameter |circle |diameter
float8 |circle_distance |circle circle |distance between
float8 |circle_radius |circle |radius
float8 |date_part |text abstime |extract field from abstime
float8 |date_part |text date |extract field from date
float8 |date_part |text datetime |extract field from datetime
float8 |date_part |text reltime |extract field from reltime
float8 |date_part |text time |extract field from time
float8 |date_part |text timespan |extract field from timespan
float8 |datetime_part |text datetime |extract field from datetime
float8 |dcbrt |float8 |cube root
float8 |dexp |float8 |exponential
float8 |diameter |circle |
float8 |dist_cpoly |circle polygon|distance between
float8 |dist_lb |line box |distance between
float8 |dist_pb |point box |distance between
float8 |dist_pl |point line |distance between
float8 |dist_ppath |point path |distance between
float8 |dist_ps |point lseg |distance between
float8 |dist_sb |lseg box |distance between
float8 |dist_sl |lseg line |distance between
float8 |dlog1 |float8 |natural logarithm (in psql, protec
float8 |dpow |float8 float8 |exponentiation
float8 |dround |float8 |truncate to integer
float8 |dsqrt |float8 |square root
float8 |dtrunc |float8 |truncate to integer
float8 |eqjoinsel |oid oid int2 o|selectivity
float8 |eqsel |oid oid int2 i|general selectivity
float8 |float |float4 |convert float4 to float8
float8 |float |float8 |convert float8 to float8 (no-op)
float8 |float48div |float4 float8 |divide
float8 |float48mi |float4 float8 |subtract
float8 |float48mul |float4 float8 |multiply
float8 |float48pl |float4 float8 |addition
float8 |float8 |float4 |convert float4 to float8
float8 |float8 |float8 |convert float8 to float8 (no-op)
float8 |float8 |int2 |convert int2 to float8
float8 |float8 |int4 |convert int4 to float8
float8 |float8 |int8 |convert int8 to float8
float8 |float84div |float8 float4 |divide
float8 |float84mi |float8 float4 |subtract
float8 |float84mul |float8 float4 |multiply
float8 |float84pl |float8 float4 |addition
float8 |float8abs |float8 |absolute value
float8 |float8div |float8 float8 |divide
float8 |float8inc |float8 |
float8 |float8larger |float8 float8 |
float8 |float8mi |float8 float8 |subtract
float8 |float8mul |float8 float8 |multiply
float8 |float8pl |float8 float8 |addition
float8 |float8smaller |float8 float8 |
float8 |float8um |float8 |subtract
float8 |ftod |float4 |convert
float8 |gistnpage |oid oid int2 i|gist
float8 |gistsel |oid oid int2 i|gist selectivity
float8 |hashnpage |oid oid int2 i|hash
float8 |hashsel |oid oid int2 i|selectivity
float8 |height |box |
float8 |i2tod |int2 |convert
float8 |i4tod |int4 |convert
float8 |i8tod |int8 |convert int8 to float8
float8 |intgtjoinsel |oid oid int2 o|selectivity
float8 |intgtsel |oid oid int2 i|selectivity
float8 |intltjoinsel |oid oid int2 o|selectivity
float8 |intltsel |oid oid int2 i|selectivity
float8 |length |lseg |distance between endpoints
float8 |length |path |sum of lengths of path segments
float8 |line_distance |line line |distance between
float8 |lseg_distance |lseg lseg |distance between
float8 |lseg_length |lseg |distance between endpoints
float8 |neqjoinsel |oid oid int2 o|selectivity
float8 |neqsel |oid oid int2 i|not-equal selectivity
float8 |path_distance |path path |distance between
float8 |path_length |path |sum of path segments
float8 |point_distance |point point |distance between
float8 |point_slope |point point |slope between points
float8 |poly_distance |polygon polygo|distance between
float8 |radius |circle |
float8 |rtnpage |oid oid int2 i|r-tree
float8 |rtsel |oid oid int2 i|r-tree
float8 |slope |point point |
float8 |timespan_part |text timespan |extract field from timespan
float8 |width |box |
int2 |dtoi2 |float8 |convert
int2 |ftoi2 |float4 |convert
int2 |i4toi2 |int4 |convert
int2 |int2 |float4 |convert float4 to int2
int2 |int2 |float8 |convert float8 to int2
int2 |int2 |int2 |convert int2 to int2 (no-op)
int2 |int2 |int4 |convert int4 to int2
int2 |int2 |text |convert
int2 |int2div |int2 int2 |divide
int2 |int2fac |int2 |
int2 |int2inc |int2 |
int2 |int2larger |int2 int2 |larger of two
int2 |int2mi |int2 int2 |subtract
int2 |int2mod |int2 int2 |modulus
int2 |int2mul |int2 int2 |multiply
int2 |int2pl |int2 int2 |addition
int2 |int2smaller |int2 int2 |smaller of two
int2 |int2um |int2 |subtract
int2 |text_int2 |text |convert
int4 |array_assgn |int4 int4 int4|array
int4 |array_clip |int4 int4 int4|array
int4 |array_ref |int4 int4 int4|array
int4 |array_set |int4 int4 int4|array
int4 |bpcharcmp |bpchar bpchar |less-equal-greater
int4 |bpcharlen |bpchar |octet length
int4 |bpcharoctetlen |bpchar |octet length
int4 |btabstimecmp |abstime abstim|btree less-equal-greater
int4 |btcharcmp |char char |btree less-equal-greater
int4 |btfloat4cmp |float4 float4 |btree less-equal-greater
int4 |btfloat8cmp |float8 float8 |btree less-equal-greater
int4 |btint24cmp |int2 int4 |btree less-equal-greater
int4 |btint2cmp |int2 int2 |btree less-equal-greater
int4 |btint42cmp |int4 int2 |btree less-equal-greater
int4 |btint4cmp |int4 int4 |btree less-equal-greater
int4 |btnamecmp |name name |btree less-equal-greater
int4 |btoid8cmp |oid8 oid8 |btree less-equal-greater
int4 |btoidcmp |oid oid |btree less-equal-greater
int4 |bttextcmp |text text |btree less-equal-greater
int4 |byteaGetBit |bytea int4 |
int4 |byteaGetByte |bytea int4 |
int4 |byteaGetSize |bytea |
int4 |char |bpchar |convert to char
int4 |currval |text |sequence current value
int4 |date_cmp |date date |less-equal-greater
int4 |date_mi |date date |subtract
int4 |datetime_cmp |datetime datet|less-equal-greater
int4 |dtoi4 |float8 |convert
int4 |ftoi4 |float4 |convert
int4 |hashbpchar |bpchar |hash
int4 |hashchar |char char |hash
int4 |hashfloat4 |float4 float4 |hash
int4 |hashfloat8 |float8 float8 |hash
int4 |hashint2 |int2 int2 |hash
int4 |hashint4 |int4 int4 |hash
int4 |hashname |name name |hash
int4 |hashoid |oid oid |hash
int4 |hashoid8 |oid8 oid8 |hash
int4 |hashtext |text text |hash
int4 |hashvarchar |varchar |hash
int4 |i2toi4 |int2 |convert
int4 |int |int4 |convert int4 to int4 (no-op)
int4 |int24div |int2 int4 |divide
int4 |int24eq |int2 int4 |equal
int4 |int24ge |int2 int4 |greater-than-or-equal
int4 |int24gt |int2 int4 |greater-than
int4 |int24le |int2 int4 |less-than-or-equal
int4 |int24lt |int2 int4 |less-than
int4 |int24mi |int2 int4 |subtract
int4 |int24mod |int2 int4 |modulus
int4 |int24mul |int2 int4 |multiply
int4 |int24ne |int2 int4 |not equal
int4 |int24pl |int2 int4 |addition
int4 |int4 |float4 |convert float4 to int4
int4 |int4 |float8 |convert float8 to int4
int4 |int4 |int2 |convert int2 to int4
int4 |int4 |int4 |convert int4 to int4 (no-op)
int4 |int4 |int8 |convert int8 to int4
int4 |int4 |text |convert
int4 |int42div |int4 int2 |divide
int4 |int42eq |int4 int2 |equal
int4 |int42ge |int4 int2 |greater-than-or-equal
int4 |int42gt |int4 int2 |greater-than
int4 |int42le |int4 int2 |less-than-or-equal
int4 |int42lt |int4 int2 |less-than
int4 |int42mi |int4 int2 |subtract
int4 |int42mod |int4 int2 |modulus
int4 |int42mul |int4 int2 |multiply
int4 |int42ne |int4 int2 |not equal
int4 |int42pl |int4 int2 |addition
int4 |int4div |int4 int4 |divide
int4 |int4fac |int4 |fraction
int4 |int4inc |int4 |
int4 |int4larger |int4 int4 |larger of two
int4 |int4mi |int4 int4 |subtract
int4 |int4mod |int4 int4 |modulus
int4 |int4mul |int4 int4 |multiply
int4 |int4pl |int4 int4 |addition
int4 |int4smaller |int4 int4 |smaller of two
int4 |int4um |int4 |subtract
int4 |int84 |int8 |convert int8 to int4
int4 |length |bpchar |character length
int4 |length |text |character length
int4 |length |varchar |character length
int4 |lo_close |int4 |large object close
int4 |lo_export |oid text |large object export
int4 |lo_lseek |int4 int4 int4|large object seek
int4 |lo_open |oid int4 |large object open
int4 |lo_tell |int4 |large object position
int4 |lo_unlink |oid |large object unlink(delete)
int4 |lowrite |int4 bytea |large object write
int4 |macaddr_cmp |macaddr macadd|less-equal-greater
int4 |masklen |inet |netmask length
int4 |network_cmp |inet inet |less-equal-greater
int4 |network_masklen |inet |netmask length
int4 |nextval |text |sequence next value
int4 |octet_length |bpchar |octet length
int4 |octet_length |text |octet length
int4 |octet_length |varchar |octet length
int4 |path_npoints |path |
int4 |pointdist |point point |
int4 |points |path |
int4 |points |polygon |
int4 |poly_npoints |polygon |number of points in polygon
int4 |pqtest |text |
int4 |rt_poly_size |polygon int4 |r-tree
int4 |seteval |oid |
int4 |setval |text int4 |sequence set value
int4 |strpos |text text |find position of substring
int4 |text_int4 |text |convert
int4 |textlen |text |length
int4 |textoctetlen |text |octet length
int4 |textpos |text text |return position of substring
int4 |time_cmp |time time |less-equal-greater
int4 |timespan_cmp |timespan times|less-equal-greater
int4 |userfntest |int4 |
int4 |varcharcmp |varchar varcha|less-equal-greater
int4 |varcharlen |varchar |character length
int4 |varcharoctetlen |varchar |octet length
int8 |dtoi8 |float8 |convert float8 to int8
int8 |int48 |int4 |convert int4 to int8
int8 |int48div |int4 int8 |divide
int8 |int48mi |int4 int8 |subtraction
int8 |int48mul |int4 int8 |multiply
int8 |int48pl |int4 int8 |addition
int8 |int8 |float8 |convert float8 to int8
int8 |int8 |int4 |convert int4 to int8
int8 |int8 |int8 |convert int8 to int8 (no-op)
int8 |int84div |int8 int4 |divide
int8 |int84mi |int8 int4 |subtraction
int8 |int84mul |int8 int4 |multiply
int8 |int84pl |int8 int4 |addition
int8 |int8div |int8 int8 |divide
int8 |int8larger |int8 int8 |larger of two
int8 |int8mi |int8 int8 |subtraction
int8 |int8mul |int8 int8 |multiply
int8 |int8pl |int8 int8 |addition
int8 |int8smaller |int8 int8 |smaller of two
int8 |int8um |int8 |unary minus
line |line |point point |
line |line_construct_pp |point point |line from points
lseg |box_diagonal |box |box diagonal
lseg |lseg |box |
lseg |lseg |point point |
lseg |lseg_construct |point point |convert points to line segment
money |cash_div_flt4 |money float4 |divide
money |cash_div_flt8 |money float8 |divide
money |cash_div_int2 |money int2 |divide
money |cash_div_int4 |money int4 |divide
money |cash_mi |money money |subtract
money |cash_mul_flt4 |money float4 |multiply
money |cash_mul_flt8 |money float8 |multiply
money |cash_mul_int2 |money int2 |multiply
money |cash_mul_int4 |money int4 |multiply
money |cash_pl |money money |addition
money |cashlarger |money money |
money |cashsmaller |money money |
money |flt4_mul_cash |float4 money |multiply
money |flt8_mul_cash |float8 money |multiply
money |int2_mul_cash |int2 money |multiply
money |int4_mul_cash |int4 money |multiply
name |bpchar_name |bpchar |convert
name |getdatabaseencoding| |
name |getpgusername | |(internal)
name |name |bpchar |convert
name |name |text |convert
name |name |varchar |convert
name |pg_get_userbyid |int4 |user name by UID (with fallback)
name |text_name |text |convert
oid |lo_creat |int4 |large object create
oid |lo_import |text |large object import
oid |oid |text |convert
oid |regproctooid |regproc |get oid for regproc
oid |text_oid |text |convert
path |path |polygon |
path |path_add |path path |addition
path |path_add_pt |path point |addition
path |path_close |path |
path |path_div_pt |path point |divide
path |path_mul_pt |path point |multiply
path |path_open |path |
path |path_sub_pt |path point |subtract
path |pclose |path |
path |poly_path |polygon |convert polygon to path
path |popen |path |
path |upgradepath |path |
point |box_center |box |center of
point |center |box |
point |center |circle |
point |center |polygon |
point |circle_center |circle |center of
point |close_lb |line box |closest point to line on box
point |close_ls |line lseg |closest point to line on line segm
point |close_lseg |lseg lseg |closest point to line segment on l
point |close_pb |point box |closest point on box
point |close_pl |point line |closest point on line
point |close_ps |point lseg |closest point on line segment
point |close_sb |lseg box |closest point to line segment on b
point |close_sl |lseg line |closest point to line segment on l
point |line_interpt |line line |intersection point
point |lseg_center |lseg |center of
point |lseg_interpt |lseg lseg |
point |path_center |path |center of
point |point |circle |convert
point |point |float8 float8 |convert x, y to point
point |point |lseg lseg |convert
point |point_add |point point |add points (translate)
point |point_div |point point |divide points (scale/rotate)
point |point_mul |point point |multiply points (scale/rotate)
point |point_sub |point point |subtract points (translate)
point |poly_center |polygon |center of
polygon |box_poly |box |convert box to polygon
polygon |circle_poly |int4 circle |convert
polygon |dist_pc |point circle |distance between
polygon |path_poly |path |convert path to polygon
polygon |polygon |box |convert
polygon |polygon |circle |convert
polygon |polygon |int4 circle |convert
polygon |polygon |path |convert
polygon |revertpoly |polygon |
polygon |rt_poly_inter |polygon polygo|r-tree
polygon |rt_poly_union |polygon polygo|r-tree
polygon |upgradepoly |polygon |
reltime |int4reltime |int4 |convert
reltime |intervalrel |tinterval |
reltime |reltime |reltime |convert
reltime |reltime |timespan |convert
reltime |timespan_reltime |timespan |convert
text |broadcast |inet |broadcast address
text |btrim |text |trim both ends of string
text |btrim |text text |trim both ends of string
text |cash_words_out |money |output amount as words
text |date_zone |text datetime |
text |datetime_text |datetime |convert
text |datetime_zone |text datetime |
text |host |inet |host address
text |initcap |text |capitalize each word
text |int2_text |int2 |convert
text |int4_text |int4 |convert
text |lower |text |lowercase
text |lpad |text int4 |left-pad string to length
text |lpad |text int4 text|left-pad string to length
text |ltrim |text |remove initial characters from str
text |ltrim |text text |left-pad string to length
text |macaddr_manuf |macaddr |MAC manufacturer
text |name_text |name |convert
text |netmask |inet |netmask of address
text |network |inet |network address
text |network_broadcast |inet |broadcast address
text |network_host |inet |host address
text |network_netmask |inet |netmask of address
text |network_network |inet |network address
text |obj_description |oid |get description for object id
text |oid8types |oid8 |print type names of oid8 field
text |oid_text |oid |convert
text |pg_get_indexdef |oid |index description
text |pg_get_ruledef |name |source text of a rule
text |pg_get_viewdef |name |select statement of a view
text |rpad |text int4 |right-pad string to length
text |rpad |text int4 text|right-pad string to length
text |rtrim |text |remove trailing characters from st
text |rtrim |text text |right-pad string to length
text |substr |text int4 |return portion of string
text |substr |text int4 int4|return portion of string
text |text |datetime |convert
text |text |int2 |convert
text |text |int4 |convert
text |text |name |convert
text |text |oid |convert
text |text |timespan |convert
text |text_substr |text int4 int4|return portion of string
text |textcat |text text |concatenate
text |timeofday | |(internal)
text |timespan_text |timespan |convert
text |translate |text char char|modify string by substring replace
text |upper |text |uppercase
text |version | |PostgreSQL version string
time |datetime_time |datetime |convert
time |time |abstime |convert
time |time |datetime |convert
time |time |time |convert
timespan |age |datetime |difference between datetime and to
timespan |age |datetime datet|difference between datetimes but l
timespan |date_trunc |text timespan |truncate timespan to field
timespan |datetime_age |datetime datet|date difference preserving months
timespan |datetime_mi |datetime datet|subtract
timespan |reltime_timespan |reltime |convert reltime to timespan
timespan |text_timespan |text |convert
timespan |timespan |reltime |convert
timespan |timespan |text |convert
timespan |timespan |time |convert
timespan |timespan |timespan |convert
timespan |timespan_div |timespan float|divide
timespan |timespan_larger |timespan times|
timespan |timespan_mi |timespan times|subtract
timespan |timespan_pl |timespan times|addition
timespan |timespan_smaller |timespan times|
timespan |timespan_trunc |text timespan |truncate timespan to specified uni
timespan |timespan_um |timespan |subtract
timestamp|datetime_timestamp |datetime |convert
timestamp|now | |current transaction time
timestamp|timestamp |datetime |convert
timestamp|timestamp |timestamp |convert
tinterval|mktinterval |abstime abstim|convert to interval
varchar |varchar |name |convert
varchar |varchar |varchar int4 |
(816 rows)