|
abbrev(inet)
|
postgres |
abbreviated display of inet value |
|
abbrev(cidr)
|
postgres |
abbreviated display of cidr value |
|
abs(real)
|
postgres |
absolute value |
|
abs(double precision)
|
postgres |
absolute value |
|
abs(bigint)
|
postgres |
absolute value |
|
abs(numeric)
|
postgres |
absolute value |
|
abs(integer)
|
postgres |
absolute value |
|
abs(smallint)
|
postgres |
absolute value |
|
abstime(timestamp with time zone)
|
postgres |
convert timestamp with time zone to abstime |
|
abstime(timestamp without time zone)
|
postgres |
convert timestamp to abstime |
|
abstimeeq(abstime, abstime)
|
postgres |
equal |
|
abstimege(abstime, abstime)
|
postgres |
greater-than-or-equal |
|
abstimegt(abstime, abstime)
|
postgres |
greater-than |
|
abstimein(cstring)
|
postgres |
I/O |
|
abstimele(abstime, abstime)
|
postgres |
less-than-or-equal |
|
abstimelt(abstime, abstime)
|
postgres |
less-than |
|
abstimene(abstime, abstime)
|
postgres |
not equal |
|
abstimeout(abstime)
|
postgres |
I/O |
|
abstimerecv(internal)
|
postgres |
I/O |
|
abstimesend(abstime)
|
postgres |
I/O |
|
aclcontains(aclitem)
|
postgres |
ACL contains item? |
|
aclinsert(aclitem)
|
postgres |
add/update ACL item |
|
aclitemeq(aclitem, aclitem)
|
postgres |
equality operator for ACL items |
|
aclitemin(cstring)
|
postgres |
I/O |
|
aclitemout(aclitem)
|
postgres |
I/O |
|
aclremove(aclitem)
|
postgres |
remove ACL item |
|
acos(double precision)
|
postgres |
arccosine |
|
age(timestamp without time zone)
|
postgres |
date difference from today preserving months and years |
|
age(timestamp with time zone)
|
postgres |
date difference from today preserving months and years |
|
age(timestamp without time zone, timestamp without time zone)
|
postgres |
date difference preserving months and years |
|
age(timestamp with time zone, timestamp with time zone)
|
postgres |
date difference preserving months and years |
|
age(xid)
|
postgres |
age of a transaction ID, in transactions before current transaction |
|
any_in(cstring)
|
postgres |
I/O |
|
any_out("any")
|
postgres |
I/O |
|
anyarray_in(cstring)
|
postgres |
I/O |
|
anyarray_out(anyarray)
|
postgres |
I/O |
|
anyarray_recv(internal)
|
postgres |
I/O |
|
anyarray_send(anyarray)
|
postgres |
I/O |
|
anyelement_in(cstring)
|
postgres |
I/O |
|
anyelement_out(anyelement)
|
postgres |
I/O |
|
area(box)
|
postgres |
box area |
|
area(circle)
|
postgres |
area of circle |
|
area(path)
|
postgres |
area of a closed path |
|
areajoinsel(internal, oid, internal, smallint)
|
postgres |
join selectivity for area-comparison operators |
|
areasel(internal, oid, internal, integer)
|
postgres |
restriction selectivity for area-comparison operators |
|
array_append(anyarray, anyelement)
|
postgres |
append element onto end of array |
|
array_cat(anyarray, anyarray)
|
postgres |
concatenate two arrays |
|
array_coerce(anyarray)
|
postgres |
coerce array to another array type |
|
array_dims(anyarray)
|
postgres |
array dimensions |
|
array_eq(anyarray, anyarray)
|
postgres |
array equal |
|
array_ge(anyarray, anyarray)
|
postgres |
array greater than or equal |
|
array_gt(anyarray, anyarray)
|
postgres |
array greater than |
|
array_in(cstring, oid, integer)
|
postgres |
I/O |
|
array_larger(anyarray, anyarray)
|
postgres |
larger of two |
|
array_le(anyarray, anyarray)
|
postgres |
array less than or equal |
|
array_length_coerce(anyarray, integer, boolean)
|
postgres |
adjust any array to new element typmod |
|
array_lower(anyarray, integer)
|
postgres |
array lower dimension |
|
array_lt(anyarray, anyarray)
|
postgres |
array less than |
|
array_ne(anyarray, anyarray)
|
postgres |
array not equal |
|
array_out(anyarray)
|
postgres |
I/O |
|
array_prepend(anyelement, anyarray)
|
postgres |
prepend element onto front of array |
|
array_recv(internal, oid, integer)
|
postgres |
I/O |
|
array_send(anyarray)
|
postgres |
I/O |
|
array_smaller(anyarray, anyarray)
|
postgres |
smaller of two |
|
array_to_string(anyarray, text)
|
postgres |
concatenate array elements, using delimiter, into text |
|
array_type_length_coerce(anyarray, integer, boolean)
|
postgres |
coerce array to another type and adjust element typmod |
|
array_upper(anyarray, integer)
|
postgres |
array upper dimension |
|
arraycontained(anyarray, anyarray)
|
postgres |
is contained by |
|
arraycontains(anyarray, anyarray)
|
postgres |
contains |
|
arrayoverlap(anyarray, anyarray)
|
postgres |
overlaps |
|
ascii(text)
|
postgres |
convert first char to int4 |
|
ascii_to_mic(integer, integer, cstring, internal, integer)
|
postgres |
|
|
ascii_to_utf8(integer, integer, cstring, internal, integer)
|
postgres |
|
|
asin(double precision)
|
postgres |
arcsine |
|
atan(double precision)
|
postgres |
arctangent |
|
atan2(double precision, double precision)
|
postgres |
arctangent, two arguments |
|
big5_to_euc_tw(integer, integer, cstring, internal, integer)
|
postgres |
|
|
big5_to_mic(integer, integer, cstring, internal, integer)
|
postgres |
|
|
big5_to_utf8(integer, integer, cstring, internal, integer)
|
postgres |
|
|
bit(integer, integer)
|
postgres |
int4 to bitstring |
|
bit(bigint, integer)
|
postgres |
int8 to bitstring |
|
bit(bit, integer, boolean)
|
postgres |
adjust bit() to typmod length |
|
bit_in(cstring, oid, integer)
|
postgres |
I/O |
|
bit_length(bit)
|
postgres |
length in bits |
|
bit_length(bytea)
|
postgres |
length in bits |
|
bit_length(text)
|
postgres |
length in bits |
|
bit_out(bit)
|
postgres |
I/O |
|
bit_recv(internal, oid, integer)
|
postgres |
I/O |
|
bit_send(bit)
|
postgres |
I/O |
|
bitand(bit, bit)
|
postgres |
bitwise and |
|
bitcat(bit, bit)
|
postgres |
bitwise concatenation |
|
bitcmp(bit, bit)
|
postgres |
compare |
|
biteq(bit, bit)
|
postgres |
equal |
|
bitge(bit, bit)
|
postgres |
greater than or equal |
|
bitgt(bit, bit)
|
postgres |
greater than |
|
bitle(bit, bit)
|
postgres |
less than or equal |
|
bitlt(bit, bit)
|
postgres |
less than |
|
bitne(bit, bit)
|
postgres |
not equal |
|
bitnot(bit)
|
postgres |
bitwise not |
|
bitor(bit, bit)
|
postgres |
bitwise or |
|
bitshiftleft(bit, integer)
|
postgres |
bitwise left shift |
|
bitshiftright(bit, integer)
|
postgres |
bitwise right shift |
|
bitxor(bit, bit)
|
postgres |
bitwise exclusive or |
|
bool(integer)
|
postgres |
convert int4 to boolean |
|
booland_statefunc(boolean, boolean)
|
postgres |
boolean-and aggregate transition function |
|
booleq(boolean, boolean)
|
postgres |
equal |
|
boolge(boolean, boolean)
|
postgres |
greater-than-or-equal |
|
boolgt(boolean, boolean)
|
postgres |
greater-than |
|
boolin(cstring)
|
postgres |
I/O |
|
boolle(boolean, boolean)
|
postgres |
less-than-or-equal |
|
boollt(boolean, boolean)
|
postgres |
less-than |
|
boolne(boolean, boolean)
|
postgres |
not equal |
|
boolor_statefunc(boolean, boolean)
|
postgres |
boolean-or aggregate transition function |
|
boolout(boolean)
|
postgres |
I/O |
|
boolrecv(internal)
|
postgres |
I/O |
|
boolsend(boolean)
|
postgres |
I/O |
|
box(point, point)
|
postgres |
convert points to box |
|
box(polygon)
|
postgres |
convert polygon to bounding box |
|
box(circle)
|
postgres |
convert circle to box |
|
box_above(box, box)
|
postgres |
is above |
|
box_above_eq(box, box)
|
postgres |
is above (allows touching) |
|
box_add(box, point)
|
postgres |
add point to box (translate) |
|
box_below(box, box)
|
postgres |
is below |
|
box_below_eq(box, box)
|
postgres |
is below (allows touching) |
|
box_center(box)
|
postgres |
center of |
|
box_contain(box, box)
|
postgres |
contains? |
|
box_contained(box, box)
|
postgres |
is contained by? |
|
box_distance(box, box)
|
postgres |
distance between boxes |
|
box_div(box, point)
|
postgres |
divide box by point (scale) |
|
box_eq(box, box)
|
postgres |
equal by area |
|
box_ge(box, box)
|
postgres |
greater-than-or-equal by area |
|
box_gt(box, box)
|
postgres |
greater-than by area |
|
box_in(cstring)
|
postgres |
I/O |
|
box_intersect(box, box)
|
postgres |
box intersection (another box) |
|
box_le(box, box)
|
postgres |
less-than-or-equal by area |
|
box_left(box, box)
|
postgres |
is left of |
|
box_lt(box, box)
|
postgres |
less-than by area |
|
box_mul(box, point)
|
postgres |
multiply box by point (scale) |
|
box_out(box)
|
postgres |
I/O |
|
box_overabove(box, box)
|
postgres |
overlaps or is above |
|
box_overbelow(box, box)
|
postgres |
overlaps or is below |
|
box_overlap(box, box)
|
postgres |
overlaps |
|
box_overleft(box, box)
|
postgres |
overlaps or is left of |
|
box_overright(box, box)
|
postgres |
overlaps or is right of |
|
box_recv(internal)
|
postgres |
I/O |
|
box_right(box, box)
|
postgres |
is right of |
|
box_same(box, box)
|
postgres |
same as? |
|
box_send(box)
|
postgres |
I/O |
|
box_sub(box, point)
|
postgres |
subtract point from box (translate) |
|
bpchar(name)
|
postgres |
convert name to char(n) |
|
bpchar("char")
|
postgres |
convert char to char() |
|
bpchar(character, integer, boolean)
|
postgres |
adjust char() to typmod length |
|
bpchar_larger(character, character)
|
postgres |
larger of two |
|
bpchar_pattern_eq(character, character)
|
postgres |
|
|
bpchar_pattern_ge(character, character)
|
postgres |
|
|
bpchar_pattern_gt(character, character)
|
postgres |
|
|
bpchar_pattern_le(character, character)
|
postgres |
|
|
bpchar_pattern_lt(character, character)
|
postgres |
|
|
bpchar_pattern_ne(character, character)
|
postgres |
|
|
bpchar_smaller(character, character)
|
postgres |
smaller of two |
|
bpcharcmp(character, character)
|
postgres |
less-equal-greater |
|
bpchareq(character, character)
|
postgres |
equal |
|
bpcharge(character, character)
|
postgres |
greater-than-or-equal |
|
bpchargt(character, character)
|
postgres |
greater-than |
|
bpchariclike(character, text)
|
postgres |
matches LIKE expression, case-insensitive |
|
bpcharicnlike(character, text)
|
postgres |
does not match LIKE expression, case-insensitive |
|
bpcharicregexeq(character, text)
|
postgres |
matches regex., case-insensitive |
|
bpcharicregexne(character, text)
|
postgres |
does not match regex., case-insensitive |
|
bpcharin(cstring, oid, integer)
|
postgres |
I/O |
|
bpcharle(character, character)
|
postgres |
less-than-or-equal |
|
bpcharlike(character, text)
|
postgres |
matches LIKE expression |
|
bpcharlt(character, character)
|
postgres |
less-than |
|
bpcharne(character, character)
|
postgres |
not equal |
|
bpcharnlike(character, text)
|
postgres |
does not match LIKE expression |
|
bpcharout(character)
|
postgres |
I/O |
|
bpcharrecv(internal, oid, integer)
|
postgres |
I/O |
|
bpcharregexeq(character, text)
|
postgres |
matches regex., case-sensitive |
|
bpcharregexne(character, text)
|
postgres |
does not match regex., case-sensitive |
|
bpcharsend(character)
|
postgres |
I/O |
|
broadcast(inet)
|
postgres |
broadcast address of network |
|
btabstimecmp(abstime, abstime)
|
postgres |
btree less-equal-greater |
|
btarraycmp(anyarray, anyarray)
|
postgres |
btree less-equal-greater |
|
btbeginscan(internal, internal, internal)
|
postgres |
btree(internal) |
|
btboolcmp(boolean, boolean)
|
postgres |
btree less-equal-greater |
|
btbpchar_pattern_cmp(character, character)
|
postgres |
|
|
btbuild(internal, internal, internal)
|
postgres |
btree(internal) |
|
btbulkdelete(internal, internal, internal, internal)
|
postgres |
btree(internal) |
|
btcharcmp("char", "char")
|
postgres |
btree less-equal-greater |
|
btcostestimate(internal, internal, internal, internal, internal, internal, internal, internal)
|
postgres |
btree(internal) |
|
btendscan(internal)
|
postgres |
btree(internal) |
|
btfloat48cmp(real, double precision)
|
postgres |
|
|
btfloat4cmp(real, real)
|
postgres |
btree less-equal-greater |
|
btfloat84cmp(double precision, real)
|
postgres |
|
|
btfloat8cmp(double precision, double precision)
|
postgres |
btree less-equal-greater |
|
btgetmulti(internal, internal, internal, internal)
|
postgres |
btree(internal) |
|
btgettuple(internal, internal)
|
postgres |
btree(internal) |
|
btinsert(internal, internal, internal, internal, internal, internal)
|
postgres |
btree(internal) |
|
btint24cmp(smallint, integer)
|
postgres |
|
|
btint28cmp(smallint, bigint)
|
postgres |
|
|
btint2cmp(smallint, smallint)
|
postgres |
btree less-equal-greater |
|
btint42cmp(integer, smallint)
|
postgres |
|
|
btint48cmp(integer, bigint)
|
postgres |
|
|
btint4cmp(integer, integer)
|
postgres |
btree less-equal-greater |
|
btint82cmp(bigint, smallint)
|
postgres |
|
|
btint84cmp(bigint, integer)
|
postgres |
|
|
btint8cmp(bigint, bigint)
|
postgres |
btree less-equal-greater |
|
btmarkpos(internal)
|
postgres |
btree(internal) |
|
btname_pattern_cmp(name, name)
|
postgres |
|
|
btnamecmp(name, name)
|
postgres |
btree less-equal-greater |
|
btoidcmp(oid, oid)
|
postgres |
btree less-equal-greater |
|
btoidvectorcmp(oidvector, oidvector)
|
postgres |
btree less-equal-greater |
|
btoptions(boolean)
|
postgres |
btree(internal) |
|
btreltimecmp(reltime, reltime)
|
postgres |
btree less-equal-greater |
|
btrescan(internal, internal)
|
postgres |
btree(internal) |
|
btrestrpos(internal)
|
postgres |
btree(internal) |
|
btrim(text, text)
|
postgres |
trim selected characters from both ends of string |
|
btrim(text)
|
postgres |
trim spaces from both ends of string |
|
btrim(bytea, bytea)
|
postgres |
trim both ends of string |
|
bttext_pattern_cmp(text, text)
|
postgres |
|
|
bttextcmp(text, text)
|
postgres |
btree less-equal-greater |
|
bttidcmp(tid, tid)
|
postgres |
btree less-equal-greater |
|
bttintervalcmp(tinterval, tinterval)
|
postgres |
btree less-equal-greater |
|
btvacuumcleanup(internal, internal)
|
postgres |
btree(internal) |
|
byteacat(bytea, bytea)
|
postgres |
concatenate |
|
byteacmp(bytea, bytea)
|
postgres |
less-equal-greater |
|
byteaeq(bytea, bytea)
|
postgres |
equal |
|
byteage(bytea, bytea)
|
postgres |
greater-than-or-equal |
|
byteagt(bytea, bytea)
|
postgres |
greater-than |
|
byteain(cstring)
|
postgres |
I/O |
|
byteale(bytea, bytea)
|
postgres |
less-than-or-equal |
|
bytealike(bytea, bytea)
|
postgres |
matches LIKE expression |
|
bytealt(bytea, bytea)
|
postgres |
less-than |
|
byteane(bytea, bytea)
|
postgres |
not equal |
|
byteanlike(bytea, bytea)
|
postgres |
does not match LIKE expression |
|
byteaout(bytea)
|
postgres |
I/O |
|
bytearecv(internal)
|
postgres |
I/O |
|
byteasend(bytea)
|
postgres |
I/O |
|
cash_cmp(money, money)
|
postgres |
btree less-equal-greater |
|
cash_div_flt4(money, real)
|
postgres |
divide |
|
cash_div_flt8(money, double precision)
|
postgres |
divide |
|
cash_div_int2(money, smallint)
|
postgres |
divide |
|
cash_div_int4(money, integer)
|
postgres |
divide |
|
cash_eq(money, money)
|
postgres |
equal |
|
cash_ge(money, money)
|
postgres |
greater-than-or-equal |
|
cash_gt(money, money)
|
postgres |
greater-than |
|
cash_in(cstring)
|
postgres |
I/O |
|
cash_le(money, money)
|
postgres |
less-than-or-equal |
|
cash_lt(money, money)
|
postgres |
less-than |
|
cash_mi(money, money)
|
postgres |
subtract |
|
cash_mul_flt4(money, real)
|
postgres |
multiply |
|
cash_mul_flt8(money, double precision)
|
postgres |
multiply |
|
cash_mul_int2(money, smallint)
|
postgres |
multiply |
|
cash_mul_int4(money, integer)
|
postgres |
multiply |
|
cash_ne(money, money)
|
postgres |
not equal |
|
cash_out(money)
|
postgres |
I/O |
|
cash_pl(money, money)
|
postgres |
add |
|
cash_recv(internal)
|
postgres |
I/O |
|
cash_send(money)
|
postgres |
I/O |
|
cash_words(money)
|
postgres |
output amount as words |
|
cashlarger(money, money)
|
postgres |
larger of two |
|
cashsmaller(money, money)
|
postgres |
smaller of two |
|
cbrt(double precision)
|
postgres |
cube root |
|
ceil(double precision)
|
postgres |
smallest integer >= value |
|
ceil(numeric)
|
postgres |
smallest integer >= value |
|
ceiling(double precision)
|
postgres |
smallest integer >= value |
|
ceiling(numeric)
|
postgres |
smallest integer >= value |
|
center(box)
|
postgres |
center of |
|
center(circle)
|
postgres |
center of |
|
char(integer)
|
postgres |
convert int4 to char |
|
char(text)
|
postgres |
convert text to char |
|
char_length(text)
|
postgres |
character length |
|
char_length(character)
|
postgres |
character length |
|
character_length(character)
|
postgres |
character length |
|
character_length(text)
|
postgres |
character length |
|
chareq("char", "char")
|
postgres |
equal |
|
charge("char", "char")
|
postgres |
greater-than-or-equal |
|
chargt("char", "char")
|
postgres |
greater-than |
|
charin(cstring)
|
postgres |
I/O |
|
charle("char", "char")
|
postgres |
less-than-or-equal |
|
charlt("char", "char")
|
postgres |
less-than |
|
charne("char", "char")
|
postgres |
not equal |
|
charout("char")
|
postgres |
I/O |
|
charrecv(internal)
|
postgres |
I/O |
|
charsend("char")
|
postgres |
I/O |
|
chr(integer)
|
postgres |
convert int4 to char |
|
cideq(cid, cid)
|
postgres |
equal |
|
cidin(cstring)
|
postgres |
I/O |
|
cidout(cid)
|
postgres |
I/O |
|
cidr(text)
|
postgres |
text to cidr |
|
cidr(inet)
|
postgres |
coerce inet to cidr |
|
cidr_in(cstring)
|
postgres |
I/O |
|
cidr_out(cidr)
|
postgres |
I/O |
|
cidr_recv(internal)
|
postgres |
I/O |
|
cidr_send(cidr)
|
postgres |
I/O |
|
cidrecv(internal)
|
postgres |
I/O |
|
cidsend(cid)
|
postgres |
I/O |
|
circle(point, double precision)
|
postgres |
convert point and radius to circle |
|
circle(polygon)
|
postgres |
convert polygon to circle |
|
circle(box)
|
postgres |
convert box to circle |
|
circle_above(circle, circle)
|
postgres |
is above |
|
circle_add_pt(circle, point)
|
postgres |
add |
|
circle_below(circle, circle)
|
postgres |
is below |
|
circle_center(circle)
|
postgres |
center of |
|
circle_contain(circle, circle)
|
postgres |
contains? |
|
circle_contain_pt(circle, point)
|
postgres |
circle contains point? |
|
circle_contained(circle, circle)
|
postgres |
is contained by? |
|
circle_distance(circle, circle)
|
postgres |
distance between |
|
circle_div_pt(circle, point)
|
postgres |
divide |
|
circle_eq(circle, circle)
|
postgres |
equal by area |
|
circle_ge(circle, circle)
|
postgres |
greater-than-or-equal by area |
|
circle_gt(circle, circle)
|
postgres |
greater-than by area |
|
circle_in(cstring)
|
postgres |
I/O |
|
circle_le(circle, circle)
|
postgres |
less-than-or-equal by area |
|
circle_left(circle, circle)
|
postgres |
is left of |
|
circle_lt(circle, circle)
|
postgres |
less-than by area |
|
circle_mul_pt(circle, point)
|
postgres |
multiply |
|
circle_ne(circle, circle)
|
postgres |
not equal by area |
|
circle_out(circle)
|
postgres |
I/O |
|
circle_overabove(circle, circle)
|
postgres |
overlaps or is above |
|
circle_overbelow(circle, circle)
|
postgres |
overlaps or is below |
|
circle_overlap(circle, circle)
|
postgres |
overlaps |
|
circle_overleft(circle, circle)
|
postgres |
overlaps or is left of |
|
circle_overright(circle, circle)
|
postgres |
overlaps or is right of |
|
circle_recv(internal)
|
postgres |
I/O |
|
circle_right(circle, circle)
|
postgres |
is right of |
|
circle_same(circle, circle)
|
postgres |
same as? |
|
circle_send(circle)
|
postgres |
I/O |
|
circle_sub_pt(circle, point)
|
postgres |
subtract |
|
clock_timestamp()
|
postgres |
current clock time |
|
close_lb(line, box)
|
postgres |
closest point to line on box |
|
close_ls(line, lseg)
|
postgres |
closest point to line on line segment |
|
close_lseg(lseg, lseg)
|
postgres |
closest point to line segment on line segment |
|
close_pb(point, box)
|
postgres |
closest point on box |
|
close_pl(point, line)
|
postgres |
closest point on line |
|
close_ps(point, lseg)
|
postgres |
closest point on line segment |
|
close_sb(lseg, box)
|
postgres |
closest point to line segment on box |
|
close_sl(lseg, line)
|
postgres |
closest point to line segment on line |
|
col_description(oid, integer)
|
postgres |
get description for table column |
|
contjoinsel(internal, oid, internal, smallint)
|
postgres |
join selectivity for containment comparison operators |
|
contsel(internal, oid, internal, integer)
|
postgres |
restriction selectivity for containment comparison operators |
|
convert(text, name, name)
|
postgres |
convert string with specified encoding names |
|
convert(text, name)
|
postgres |
convert string with specified destination encoding name |
|
convert_using(text, text)
|
postgres |
convert string with specified conversion name |
|
cos(double precision)
|
postgres |
cosine |
|
cot(double precision)
|
postgres |
cotangent |
|
cstring_in(cstring)
|
postgres |
I/O |
|
cstring_out(cstring)
|
postgres |
I/O |
|
cstring_recv(internal)
|
postgres |
I/O |
|
cstring_send(cstring)
|
postgres |
I/O |
|
current_database()
|
postgres |
returns the current database |
|
current_schema()
|
postgres |
current schema name |
|
current_schemas(boolean)
|
postgres |
current schema search list |
|
current_setting(text)
|
postgres |
SHOW X as a function |
|
current_user()
|
postgres |
current user name |
|
currtid(oid, tid)
|
postgres |
latest tid of a tuple |
|
currtid2(text, tid)
|
postgres |
latest tid of a tuple |
|
currval(regclass)
|
postgres |
sequence current value |
|
date(text)
|
postgres |
convert text to date |
|
date(abstime)
|
postgres |
convert abstime to date |
|
date(timestamp with time zone)
|
postgres |
convert timestamp with time zone to date |
|
date(timestamp without time zone)
|
postgres |
convert timestamp to date |
|
date_cmp(date, date)
|
postgres |
less-equal-greater |
|
date_cmp_timestamp(date, timestamp without time zone)
|
postgres |
less-equal-greater |
|
date_cmp_timestamptz(date, timestamp with time zone)
|
postgres |
less-equal-greater |
|
date_eq(date, date)
|
postgres |
equal |
|
date_eq_timestamp(date, timestamp without time zone)
|
postgres |
equal |
|
date_eq_timestamptz(date, timestamp with time zone)
|
postgres |
equal |
|
date_ge(date, date)
|
postgres |
greater-than-or-equal |
|
date_ge_timestamp(date, timestamp without time zone)
|
postgres |
greater-than-or-equal |
|
date_ge_timestamptz(date, timestamp with time zone)
|
postgres |
greater-than-or-equal |
|
date_gt(date, date)
|
postgres |
greater-than |
|
date_gt_timestamp(date, timestamp without time zone)
|
postgres |
greater-than |
|
date_gt_timestamptz(date, timestamp with time zone)
|
postgres |
greater-than |
|
date_in(cstring)
|
postgres |
I/O |
|
date_larger(date, date)
|
postgres |
larger of two |
|
date_le(date, date)
|
postgres |
less-than-or-equal |
|
date_le_timestamp(date, timestamp without time zone)
|
postgres |
less-than-or-equal |
|
date_le_timestamptz(date, timestamp with time zone)
|
postgres |
less-than-or-equal |
|
date_lt(date, date)
|
postgres |
less-than |
|
date_lt_timestamp(date, timestamp without time zone)
|
postgres |
less-than |
|
date_lt_timestamptz(date, timestamp with time zone)
|
postgres |
less-than |
|
date_mi(date, date)
|
postgres |
subtract |
|
date_mi_interval(date, interval)
|
postgres |
subtract |
|
date_mii(date, integer)
|
postgres |
subtract |
|
date_ne(date, date)
|
postgres |
not equal |
|
date_ne_timestamp(date, timestamp without time zone)
|
postgres |
not equal |
|
date_ne_timestamptz(date, timestamp with time zone)
|
postgres |
not equal |
|
date_out(date)
|
postgres |
I/O |
|
date_part(text, abstime)
|
postgres |
extract field from abstime |
|
date_part(text, interval)
|
postgres |
extract field from interval |
|
date_part(text, timestamp with time zone)
|
postgres |
extract field from timestamp with time zone |
|
date_part(text, time with time zone)
|
postgres |
extract field from time with time zone |
|
date_part(text, time without time zone)
|
postgres |
extract field from time |
|
date_part(text, date)
|
postgres |
extract field from date |
|
date_part(text, reltime)
|
postgres |
extract field from reltime |
|
date_part(text, timestamp without time zone)
|
postgres |
extract field from timestamp |
|
date_pl_interval(date, interval)
|
postgres |
add |
|
date_pli(date, integer)
|
postgres |
add |
|
date_recv(internal)
|
postgres |
I/O |
|
date_send(date)
|
postgres |
I/O |
|
date_smaller(date, date)
|
postgres |
smaller of two |
|
date_trunc(text, interval)
|
postgres |
truncate interval to specified units |
|
date_trunc(text, timestamp with time zone)
|
postgres |
truncate timestamp with time zone to specified units |
|
date_trunc(text, timestamp without time zone)
|
postgres |
truncate timestamp to specified units |
|
datetime_pl(date, time without time zone)
|
postgres |
convert date and time to timestamp |
|
datetimetz_pl(date, time with time zone)
|
postgres |
convert date and time with time zone to timestamp with time zone |
|
dcbrt(double precision)
|
postgres |
cube root |
|
decode(text, text)
|
postgres |
Convert ascii-encoded text string into bytea value |
|
degrees(double precision)
|
postgres |
radians to degrees |
|
dexp(double precision)
|
postgres |
natural exponential (e^x) |
|
diagonal(box)
|
postgres |
box diagonal |
|
diameter(circle)
|
postgres |
diameter of circle |
|
dist_cpoly(circle, polygon)
|
postgres |
distance between |
|
dist_lb(line, box)
|
postgres |
distance between line and box |
|
dist_pb(point, box)
|
postgres |
distance between point and box |
|
dist_pc(point, circle)
|
postgres |
distance between point and circle |
|
dist_pl(point, line)
|
postgres |
distance between point and line |
|
dist_ppath(point, path)
|
postgres |
distance between point and path |
|
dist_ps(point, lseg)
|
postgres |
distance between |
|
dist_sb(lseg, box)
|
postgres |
distance between segment and box |
|
dist_sl(lseg, line)
|
postgres |
distance between lseg and line |
|
dlog1(double precision)
|
postgres |
natural logarithm |
|
dlog10(double precision)
|
postgres |
base 10 logarithm |
|
domain_in(cstring, oid, integer)
|
postgres |
I/O |
|
domain_recv(internal, oid, integer)
|
postgres |
I/O |
|
dpow(double precision, double precision)
|
postgres |
exponentiation (x^y) |
|
dround(double precision)
|
postgres |
round to nearest integer |
|
dsqrt(double precision)
|
postgres |
square root |
|
dtrunc(double precision)
|
postgres |
truncate to integer |
|
encode(bytea, text)
|
postgres |
Convert bytea value into some ascii-only text string |
|
eqjoinsel(internal, oid, internal, smallint)
|
postgres |
join selectivity of = and related operators |
|
eqsel(internal, oid, internal, integer)
|
postgres |
restriction selectivity of = and related operators |
|
euc_cn_to_mic(integer, integer, cstring, internal, integer)
|
postgres |
|
|
euc_cn_to_utf8(integer, integer, cstring, internal, integer)
|
postgres |
|
|
euc_jp_to_mic(integer, integer, cstring, internal, integer)
|
postgres |
|
|
euc_jp_to_sjis(integer, integer, cstring, internal, integer)
|
postgres |
|
|
euc_jp_to_utf8(integer, integer, cstring, internal, integer)
|
postgres |
|
|
euc_kr_to_mic(integer, integer, cstring, internal, integer)
|
postgres |
|
|
euc_kr_to_utf8(integer, integer, cstring, internal, integer)
|
postgres |
|
|
euc_tw_to_big5(integer, integer, cstring, internal, integer)
|
postgres |
|
|
euc_tw_to_mic(integer, integer, cstring, internal, integer)
|
postgres |
|
|
euc_tw_to_utf8(integer, integer, cstring, internal, integer)
|
postgres |
|
|
exp(double precision)
|
postgres |
exponential |
|
exp(numeric)
|
postgres |
e raised to the power of n |
|
factorial(bigint)
|
postgres |
factorial |
|
family(inet)
|
postgres |
address family (4 for IPv4, 6 for IPv6) |
|
float4(integer)
|
postgres |
convert int4 to float4 |
|
float4(smallint)
|
postgres |
convert int2 to float4 |
|
float4(double precision)
|
postgres |
convert float8 to float4 |
|
float4(text)
|
postgres |
convert text to float4 |
|
float4(numeric)
|
postgres |
(internal) |
|
float4(bigint)
|
postgres |
convert int8 to float4 |
|
float48div(real, double precision)
|
postgres |
divide |
|
float48eq(real, double precision)
|
postgres |
equal |
|
float48ge(real, double precision)
|
postgres |
greater-than-or-equal |
|
float48gt(real, double precision)
|
postgres |
greater-than |
|
float48le(real, double precision)
|
postgres |
less-than-or-equal |
|
float48lt(real, double precision)
|
postgres |
less-than |
|
float48mi(real, double precision)
|
postgres |
subtract |
|
float48mul(real, double precision)
|
postgres |
multiply |
|
float48ne(real, double precision)
|
postgres |
not equal |
|
float48pl(real, double precision)
|
postgres |
add |
|
float4_accum(real)
|
postgres |
aggregate transition function |
|
float4abs(real)
|
postgres |
absolute value |
|
float4div(real, real)
|
postgres |
divide |
|
float4eq(real, real)
|
postgres |
equal |
|
float4ge(real, real)
|
postgres |
greater-than-or-equal |
|
float4gt(real, real)
|
postgres |
greater-than |
|
float4in(cstring)
|
postgres |
I/O |
|
float4larger(real, real)
|
postgres |
larger of two |
|
float4le(real, real)
|
postgres |
less-than-or-equal |
|
float4lt(real, real)
|
postgres |
less-than |
|
float4mi(real, real)
|
postgres |
subtract |
|
float4mul(real, real)
|
postgres |
multiply |
|
float4ne(real, real)
|
postgres |
not equal |
|
float4out(real)
|
postgres |
I/O |
|
float4pl(real, real)
|
postgres |
add |
|
float4recv(internal)
|
postgres |
I/O |
|
float4send(real)
|
postgres |
I/O |
|
float4smaller(real, real)
|
postgres |
smaller of two |
|
float4um(real)
|
postgres |
negate |
|
float4up(real)
|
postgres |
unary plus |
|
float8(numeric)
|
postgres |
(internal) |
|
float8(real)
|
postgres |
convert float4 to float8 |
|
float8(text)
|
postgres |
convert text to float8 |
|
float8(bigint)
|
postgres |
convert int8 to float8 |
|
float8(smallint)
|
postgres |
convert int2 to float8 |
|
float8(integer)
|
postgres |
convert int4 to float8 |
|
float84div(double precision, real)
|
postgres |
divide |
|
float84eq(double precision, real)
|
postgres |
equal |
|
float84ge(double precision, real)
|
postgres |
greater-than-or-equal |
|
float84gt(double precision, real)
|
postgres |
greater-than |
|
float84le(double precision, real)
|
postgres |
less-than-or-equal |
|
float84lt(double precision, real)
|
postgres |
less-than |
|
float84mi(double precision, real)
|
postgres |
subtract |
|
float84mul(double precision, real)
|
postgres |
multiply |
|
float84ne(double precision, real)
|
postgres |
not equal |
|
float84pl(double precision, real)
|
postgres |
add |
|
float8_accum(double precision)
|
postgres |
aggregate transition function |
|
float8_avg()
|
postgres |
AVG aggregate final function |
|
float8_corr()
|
postgres |
CORR(double, double) aggregate final function |
|
float8_covar_pop()
|
postgres |
COVAR_POP(double, double) aggregate final function |
|
float8_covar_samp()
|
postgres |
COVAR_SAMP(double, double) aggregate final function |
|
float8_regr_accum(double precision, double precision)
|
postgres |
REGR_...(double, double) transition function |
|
float8_regr_avgx()
|
postgres |
REGR_AVGX(double, double) aggregate final function |
|
float8_regr_avgy()
|
postgres |
REGR_AVGY(double, double) aggregate final function |
|
float8_regr_intercept()
|
postgres |
REGR_INTERCEPT(double, double) aggregate final function |
|
float8_regr_r2()
|
postgres |
REGR_R2(double, double) aggregate final function |
|
float8_regr_slope()
|
postgres |
REGR_SLOPE(double, double) aggregate final function |
|
float8_regr_sxx()
|
postgres |
REGR_SXX(double, double) aggregate final function |
|
float8_regr_sxy()
|
postgres |
REGR_SXY(double, double) aggregate final function |
|
float8_regr_syy()
|
postgres |
REGR_SYY(double, double) aggregate final function |
|
float8_stddev_pop()
|
postgres |
STDDEV_POP aggregate final function |
|
float8_stddev_samp()
|
postgres |
STDDEV_SAMP aggregate final function |
|
float8_var_pop()
|
postgres |
VAR_POP aggregate final function |
|
float8_var_samp()
|
postgres |
VAR_SAMP aggregate final function |
|
float8abs(double precision)
|
postgres |
absolute value |
|
float8div(double precision, double precision)
|
postgres |
divide |
|
float8eq(double precision, double precision)
|
postgres |
equal |
|
float8ge(double precision, double precision)
|
postgres |
greater-than-or-equal |
|
float8gt(double precision, double precision)
|
postgres |
greater-than |
|
float8in(cstring)
|
postgres |
I/O |
|
float8larger(double precision, double precision)
|
postgres |
larger of two |
|
float8le(double precision, double precision)
|
postgres |
less-than-or-equal |
|
float8lt(double precision, double precision)
|
postgres |
less-than |
|
float8mi(double precision, double precision)
|
postgres |
subtract |
|
float8mul(double precision, double precision)
|
postgres |
multiply |
|
float8ne(double precision, double precision)
|
postgres |
not equal |
|
float8out(double precision)
|
postgres |
I/O |
|
float8pl(double precision, double precision)
|
postgres |
add |
|
float8recv(internal)
|
postgres |
I/O |
|
float8send(double precision)
|
postgres |
I/O |
|
float8smaller(double precision, double precision)
|
postgres |
smaller of two |
|
float8um(double precision)
|
postgres |
negate |
|
float8up(double precision)
|
postgres |
unary plus |
|
floor(numeric)
|
postgres |
largest integer <= value |
|
floor(double precision)
|
postgres |
largest integer <= value |
|
flt4_mul_cash(real, money)
|
postgres |
multiply |
|
flt8_mul_cash(double precision, money)
|
postgres |
multiply |
|
fmgr_c_validator(oid)
|
postgres |
(internal) |
|
fmgr_internal_validator(oid)
|
postgres |
(internal) |
|
fmgr_sql_validator(oid)
|
postgres |
(internal) |
|
format_type(oid, integer)
|
postgres |
format a type oid and atttypmod to canonical SQL |
|
gb18030_to_utf8(integer, integer, cstring, internal, integer)
|
postgres |
|
|
gbk_to_utf8(integer, integer, cstring, internal, integer)
|
postgres |
|
|
generate_series(bigint, bigint)
|
postgres |
non-persistent series generator |
|
generate_series(integer, integer, integer)
|
postgres |
non-persistent series generator |
|
generate_series(bigint, bigint, bigint)
|
postgres |
non-persistent series generator |
|
generate_series(integer, integer)
|
postgres |
non-persistent series generator |
|
get_bit(bytea, integer)
|
postgres |
get bit |
|
get_byte(bytea, integer)
|
postgres |
get byte |
|
getdatabaseencoding()
|
postgres |
encoding name of current database |
|
getpgusername()
|
postgres |
deprecated -- use current_user |
|
ginarrayconsistent(internal, smallint, internal)
|
postgres |
GIN array support |
|
ginarrayextract(anyarray, internal)
|
postgres |
GIN array support |
|
ginbeginscan(internal, internal, internal)
|
postgres |
gin(internal) |
|
ginbuild(internal, internal, internal)
|
postgres |
gin(internal) |
|
ginbulkdelete(internal, internal, internal, internal)
|
postgres |
gin(internal) |
|
gincostestimate(internal, internal, internal, internal, internal, internal, internal, internal)
|
postgres |
gin(internal) |
|
ginendscan(internal)
|
postgres |
gin(internal) |
|
gingetmulti(internal, internal, internal, internal)
|
postgres |
gin(internal) |
|
gingettuple(internal, internal)
|
postgres |
gin(internal) |
|
gininsert(internal, internal, internal, internal, internal, internal)
|
postgres |
gin(internal) |
|
ginmarkpos(internal)
|
postgres |
gin(internal) |
|
ginoptions(boolean)
|
postgres |
gin(internal) |
|
ginrescan(internal, internal)
|
postgres |
gin(internal) |
|
ginrestrpos(internal)
|
postgres |
gin(internal) |
|
ginvacuumcleanup(internal, internal)
|
postgres |
gin(internal) |
|
gist_box_compress(internal)
|
postgres |
GiST support |
|
gist_box_consistent(internal, box, integer)
|
postgres |
GiST support |
|
gist_box_decompress(internal)
|
postgres |
GiST support |
|
gist_box_penalty(internal, internal, internal)
|
postgres |
GiST support |
|
gist_box_picksplit(internal, internal)
|
postgres |
GiST support |
|
gist_box_same(box, box, internal)
|
postgres |
GiST support |
|
gist_box_union(internal, internal)
|
postgres |
GiST support |
|
gist_circle_compress(internal)
|
postgres |
GiST support |
|
gist_circle_consistent(internal, circle, integer)
|
postgres |
GiST support |
|
gist_poly_compress(internal)
|
postgres |
GiST support |
|
gist_poly_consistent(internal, polygon, integer)
|
postgres |
GiST support |
|
gistbeginscan(internal, internal, internal)
|
postgres |
gist(internal) |
|
gistbuild(internal, internal, internal)
|
postgres |
gist(internal) |
|
gistbulkdelete(internal, internal, internal, internal)
|
postgres |
gist(internal) |
|
gistcostestimate(internal, internal, internal, internal, internal, internal, internal, internal)
|
postgres |
gist(internal) |
|
gistendscan(internal)
|
postgres |
gist(internal) |
|
gistgetmulti(internal, internal, internal, internal)
|
postgres |
gist(internal) |
|
gistgettuple(internal, internal)
|
postgres |
gist(internal) |
|
gistinsert(internal, internal, internal, internal, internal, internal)
|
postgres |
gist(internal) |
|
gistmarkpos(internal)
|
postgres |
gist(internal) |
|
gistoptions(boolean)
|
postgres |
gist(internal) |
|
gistrescan(internal, internal)
|
postgres |
gist(internal) |
|
gistrestrpos(internal)
|
postgres |
gist(internal) |
|
gistvacuumcleanup(internal, internal)
|
postgres |
gist(internal) |
|
has_database_privilege(oid, text, text)
|
postgres |
user privilege on database by user oid, database name |
|
has_database_privilege(oid, text)
|
postgres |
current user privilege on database by database oid |
|
has_database_privilege(name, oid, text)
|
postgres |
user privilege on database by username, database oid |
|
has_database_privilege(oid, oid, text)
|
postgres |
user privilege on database by user oid, database oid |
|
has_database_privilege(name, text, text)
|
postgres |
user privilege on database by username, database name |
|
has_database_privilege(text, text)
|
postgres |
current user privilege on database by database name |
|
has_function_privilege(oid, oid, text)
|
postgres |
user privilege on function by user oid, function oid |
|
has_function_privilege(name, oid, text)
|
postgres |
user privilege on function by username, function oid |
|
has_function_privilege(text, text)
|
postgres |
current user privilege on function by function name |
|
has_function_privilege(oid, text)
|
postgres |
current user privilege on function by function oid |
|
has_function_privilege(name, text, text)
|
postgres |
user privilege on function by username, function name |
|
has_function_privilege(oid, text, text)
|
postgres |
user privilege on function by user oid, function name |
|
has_language_privilege(oid, text, text)
|
postgres |
user privilege on language by user oid, language name |
|
has_language_privilege(name, text, text)
|
postgres |
user privilege on language by username, language name |
|
has_language_privilege(name, oid, text)
|
postgres |
user privilege on language by username, language oid |
|
has_language_privilege(text, text)
|
postgres |
current user privilege on language by language name |
|
has_language_privilege(oid, text)
|
postgres |
current user privilege on language by language oid |
|
has_language_privilege(oid, oid, text)
|
postgres |
user privilege on language by user oid, language oid |
|
has_schema_privilege(name, oid, text)
|
postgres |
user privilege on schema by username, schema oid |
|
has_schema_privilege(oid, text, text)
|
postgres |
user privilege on schema by user oid, schema name |
|
has_schema_privilege(name, text, text)
|
postgres |
user privilege on schema by username, schema name |
|
has_schema_privilege(text, text)
|
postgres |
current user privilege on schema by schema name |
|
has_schema_privilege(oid, text)
|
postgres |
current user privilege on schema by schema oid |
|
has_schema_privilege(oid, oid, text)
|
postgres |
user privilege on schema by user oid, schema oid |
|
has_table_privilege(oid, text)
|
postgres |
current user privilege on relation by rel oid |
|
has_table_privilege(name, text, text)
|
postgres |
user privilege on relation by username, rel name |
|
has_table_privilege(name, oid, text)
|
postgres |
user privilege on relation by username, rel oid |
|
has_table_privilege(oid, text, text)
|
postgres |
user privilege on relation by user oid, rel name |
|
has_table_privilege(oid, oid, text)
|
postgres |
user privilege on relation by user oid, rel oid |
|
has_table_privilege(text, text)
|
postgres |
current user privilege on relation by rel name |
|
has_tablespace_privilege(text, text)
|
postgres |
current user privilege on tablespace by tablespace name |
|
has_tablespace_privilege(oid, text, text)
|
postgres |
user privilege on tablespace by user oid, tablespace name |
|
has_tablespace_privilege(oid, oid, text)
|
postgres |
user privilege on tablespace by user oid, tablespace oid |
|
has_tablespace_privilege(oid, text)
|
postgres |
current user privilege on tablespace by tablespace oid |
|
has_tablespace_privilege(name, text, text)
|
postgres |
user privilege on tablespace by username, tablespace name |
|
has_tablespace_privilege(name, oid, text)
|
postgres |
user privilege on tablespace by username, tablespace oid |
|
hash_aclitem(aclitem)
|
postgres |
hash |
|
hashbeginscan(internal, internal, internal)
|
postgres |
hash(internal) |
|
hashbpchar(character)
|
postgres |
hash |
|
hashbuild(internal, internal, internal)
|
postgres |
hash(internal) |
|
hashbulkdelete(internal, internal, internal, internal)
|
postgres |
hash(internal) |
|
hashchar("char")
|
postgres |
hash |
|
hashcostestimate(internal, internal, internal, internal, internal, internal, internal, internal)
|
postgres |
hash(internal) |
|
hashendscan(internal)
|
postgres |
hash(internal) |
|
hashfloat4(real)
|
postgres |
hash |
|
hashfloat8(double precision)
|
postgres |
hash |
|
hashgetmulti(internal, internal, internal, internal)
|
postgres |
hash(internal) |
|
hashgettuple(internal, internal)
|
postgres |
hash(internal) |
|
hashinet(inet)
|
postgres |
hash |
|
hashinsert(internal, internal, internal, internal, internal, internal)
|
postgres |
hash(internal) |
|
hashint2(smallint)
|
postgres |
hash |
|
hashint2vector(int2vector)
|
postgres |
hash |
|
hashint4(integer)
|
postgres |
hash |
|
hashint8(bigint)
|
postgres |
hash |
|
hashmacaddr(macaddr)
|
postgres |
hash |
|
hashmarkpos(internal)
|
postgres |
hash(internal) |
|
hashname(name)
|
postgres |
hash |
|
hashoid(oid)
|
postgres |
hash |
|
hashoidvector(oidvector)
|
postgres |
hash |
|
hashoptions(boolean)
|
postgres |
hash(internal) |
|
hashrescan(internal, internal)
|
postgres |
hash(internal) |
|
hashrestrpos(internal)
|
postgres |
hash(internal) |
|
hashtext(text)
|
postgres |
hash |
|
hashvacuumcleanup(internal, internal)
|
postgres |
hash(internal) |
|
hashvarlena(internal)
|
postgres |
hash any varlena type |
|
height(box)
|
postgres |
box height |
|
host(inet)
|
postgres |
show address octets only |
|
hostmask(inet)
|
postgres |
hostmask of address |
|
iclikejoinsel(internal, oid, internal, smallint)
|
postgres |
join selectivity of ILIKE |
|
iclikesel(internal, oid, internal, integer)
|
postgres |
restriction selectivity of ILIKE |
|
icnlikejoinsel(internal, oid, internal, smallint)
|
postgres |
join selectivity of NOT ILIKE |
|
icnlikesel(internal, oid, internal, integer)
|
postgres |
restriction selectivity of NOT ILIKE |
|
icregexeqjoinsel(internal, oid, internal, smallint)
|
postgres |
join selectivity of case-insensitive regex match |
|
icregexeqsel(internal, oid, internal, integer)
|
postgres |
restriction selectivity of case-insensitive regex match |
|
icregexnejoinsel(internal, oid, internal, smallint)
|
postgres |
join selectivity of case-insensitive regex non-match |
|
icregexnesel(internal, oid, internal, integer)
|
postgres |
restriction selectivity of case-insensitive regex non-match |
|
inet(text)
|
postgres |
text to inet |
|
inet_client_addr()
|
postgres |
inet address of the client |
|
inet_client_port()
|
postgres |
client's port number for this connection |
|
inet_in(cstring)
|
postgres |
I/O |
|
inet_out(inet)
|
postgres |
I/O |
|
inet_recv(internal)
|
postgres |
I/O |
|
inet_send(inet)
|
postgres |
I/O |
|
inet_server_addr()
|
postgres |
inet address of the server |
|
inet_server_port()
|
postgres |
server's port number for this connection |
|
inetand(inet, inet)
|
postgres |
bitwise and |
|
inetmi(inet, inet)
|
postgres |
subtract inet values |
|
inetmi_int8(inet, bigint)
|
postgres |
subtract integer from inet value |
|
inetnot(inet)
|
postgres |
bitwise not |
|
inetor(inet, inet)
|
postgres |
bitwise or |
|
inetpl(inet, bigint)
|
postgres |
add integer to inet value |
|
initcap(text)
|
postgres |
capitalize each word |
|
int2(integer)
|
postgres |
convert int4 to int2 |
|
int2(numeric)
|
postgres |
(internal) |
|
int2(bigint)
|
postgres |
convert int8 to int2 |
|
int2(text)
|
postgres |
convert text to int2 |
|
int2(double precision)
|
postgres |
convert float8 to int2 |
|
int2(real)
|
postgres |
convert float4 to int2 |
|
int24div(smallint, integer)
|
postgres |
divide |
|
int24eq(smallint, integer)
|
postgres |
equal |
|
int24ge(smallint, integer)
|
postgres |
greater-than-or-equal |
|
int24gt(smallint, integer)
|
postgres |
greater-than |
|
int24le(smallint, integer)
|
postgres |
less-than-or-equal |
|
int24lt(smallint, integer)
|
postgres |
less-than |
|
int24mi(smallint, integer)
|
postgres |
subtract |
|
int24mod(smallint, integer)
|
postgres |
modulus |
|
int24mul(smallint, integer)
|
postgres |
multiply |
|
int24ne(smallint, integer)
|
postgres |
not equal |
|
int24pl(smallint, integer)
|
postgres |
add |
|
int28eq(smallint, bigint)
|
postgres |
equal |
|
int28ge(smallint, bigint)
|
postgres |
greater-than-or-equal |
|
int28gt(smallint, bigint)
|
postgres |
greater-than |
|
int28le(smallint, bigint)
|
postgres |
less-than-or-equal |
|
int28lt(smallint, bigint)
|
postgres |
less-than |
|
int28ne(smallint, bigint)
|
postgres |
not equal |
|
int2_accum(smallint)
|
postgres |
aggregate transition function |
|
int2_avg_accum(smallint)
|
postgres |
AVG(int2) transition function |
|
int2_mul_cash(smallint, money)
|
postgres |
multiply |
|
int2_sum(bigint, smallint)
|
postgres |
SUM(int2) transition function |
|
int2abs(smallint)
|
postgres |
absolute value |
|
int2and(smallint, smallint)
|
postgres |
bitwise and |
|
int2div(smallint, smallint)
|
postgres |
divide |
|
int2eq(smallint, smallint)
|
postgres |
equal |
|
int2ge(smallint, smallint)
|
postgres |
greater-than-or-equal |
|
int2gt(smallint, smallint)
|
postgres |
greater-than |
|
int2in(cstring)
|
postgres |
I/O |
|
int2larger(smallint, smallint)
|
postgres |
larger of two |
|
int2le(smallint, smallint)
|
postgres |
less-than-or-equal |
|
int2lt(smallint, smallint)
|
postgres |
less-than |
|
int2mi(smallint, smallint)
|
postgres |
subtract |
|
int2mod(smallint, smallint)
|
postgres |
modulus |
|
int2mul(smallint, smallint)
|
postgres |
multiply |
|
int2ne(smallint, smallint)
|
postgres |
not equal |
|
int2not(smallint)
|
postgres |
bitwise not |
|
int2or(smallint, smallint)
|
postgres |
bitwise or |
|
int2out(smallint)
|
postgres |
I/O |
|
int2pl(smallint, smallint)
|
postgres |
add |
|
int2recv(internal)
|
postgres |
I/O |
|
int2send(smallint)
|
postgres |
I/O |
|
int2shl(smallint, integer)
|
postgres |
bitwise shift left |
|
int2shr(smallint, integer)
|
postgres |
bitwise shift right |
|
int2smaller(smallint, smallint)
|
postgres |
smaller of two |
|
int2um(smallint)
|
postgres |
negate |
|
int2up(smallint)
|
postgres |
unary plus |
|
int2vectoreq(int2vector, int2vector)
|
postgres |
equal |
|
int2vectorin(cstring)
|
postgres |
I/O |
|
int2vectorout(int2vector)
|
postgres |
I/O |
|
int2vectorrecv(internal)
|
postgres |
I/O |
|
int2vectorsend(int2vector)
|
postgres |
I/O |
|
int2xor(smallint, smallint)
|
postgres |
bitwise xor |
|
int4(text)
|
postgres |
convert text to int4 |
|
int4(double precision)
|
postgres |
convert float8 to int4 |
|
int4(bit)
|
postgres |
bitstring to int4 |
|
int4(real)
|
postgres |
convert float4 to int4 |
|
int4(bigint)
|
postgres |
convert int8 to int4 |
|
int4(smallint)
|
postgres |
convert int2 to int4 |
|
int4(numeric)
|
postgres |
(internal) |
|
int4("char")
|
postgres |
convert char to int4 |
|
int4(boolean)
|
postgres |
convert boolean to int4 |
|
int42div(integer, smallint)
|
postgres |
divide |
|
int42eq(integer, smallint)
|
postgres |
equal |
|
int42ge(integer, smallint)
|
postgres |
greater-than-or-equal |
|
int42gt(integer, smallint)
|
postgres |
greater-than |
|
int42le(integer, smallint)
|
postgres |
less-than-or-equal |
|
int42lt(integer, smallint)
|
postgres |
less-than |
|
int42mi(integer, smallint)
|
postgres |
subtract |
|
int42mod(integer, smallint)
|
postgres |
modulus |
|
int42mul(integer, smallint)
|
postgres |
multiply |
|
int42ne(integer, smallint)
|
postgres |
not equal |
|
int42pl(integer, smallint)
|
postgres |
add |
|
int48div(integer, bigint)
|
postgres |
divide |
|
int48eq(integer, bigint)
|
postgres |
equal |
|
int48ge(integer, bigint)
|
postgres |
greater-than-or-equal |
|
int48gt(integer, bigint)
|
postgres |
greater-than |
|
int48le(integer, bigint)
|
postgres |
less-than-or-equal |
|
int48lt(integer, bigint)
|
postgres |
less-than |
|
int48mi(integer, bigint)
|
postgres |
subtract |
|
int48mul(integer, bigint)
|
postgres |
multiply |
|
int48ne(integer, bigint)
|
postgres |
not equal |
|
int48pl(integer, bigint)
|
postgres |
add |
|
int4_accum(integer)
|
postgres |
aggregate transition function |
|
int4_avg_accum(integer)
|
postgres |
AVG(int4) transition function |
|
int4_mul_cash(integer, money)
|
postgres |
multiply |
|
int4_sum(bigint, integer)
|
postgres |
SUM(int4) transition function |
|
int4abs(integer)
|
postgres |
absolute value |
|
int4and(integer, integer)
|
postgres |
bitwise and |
|
int4div(integer, integer)
|
postgres |
divide |
|
int4eq(integer, integer)
|
postgres |
equal |
|
int4ge(integer, integer)
|
postgres |
greater-than-or-equal |
|
int4gt(integer, integer)
|
postgres |
greater-than |
|
int4in(cstring)
|
postgres |
I/O |
|
int4inc(integer)
|
postgres |
increment |
|
int4larger(integer, integer)
|
postgres |
larger of two |
|
int4le(integer, integer)
|
postgres |
less-than-or-equal |
|
int4lt(integer, integer)
|
postgres |
less-than |
|
int4mi(integer, integer)
|
postgres |
subtract |
|
int4mod(integer, integer)
|
postgres |
modulus |
|
int4mul(integer, integer)
|
postgres |
multiply |
|
int4ne(integer, integer)
|
postgres |
not equal |
|
int4not(integer)
|
postgres |
bitwise not |
|
int4notin(integer, text)
|
postgres |
not in |
|
int4or(integer, integer)
|
postgres |
bitwise or |
|
int4out(integer)
|
postgres |
I/O |
|
int4pl(integer, integer)
|
postgres |
add |
|
int4recv(internal)
|
postgres |
I/O |
|
int4send(integer)
|
postgres |
I/O |
|
int4shl(integer, integer)
|
postgres |
bitwise shift left |
|
int4shr(integer, integer)
|
postgres |
bitwise shift right |
|
int4smaller(integer, integer)
|
postgres |
smaller of two |
|
int4um(integer)
|
postgres |
negate |
|
int4up(integer)
|
postgres |
unary plus |
|
int4xor(integer, integer)
|
postgres |
bitwise xor |
|
int8(bit)
|
postgres |
bitstring to int8 |
|
int8(oid)
|
postgres |
convert oid to int8 |
|
int8(text)
|
postgres |
convert text to int8 |
|
int8(numeric)
|
postgres |
(internal) |
|
int8(smallint)
|
postgres |
convert int2 to int8 |
|
int8(integer)
|
postgres |
convert int4 to int8 |
|
int8(real)
|
postgres |
convert float4 to int8 |
|
int8(double precision)
|
postgres |
convert float8 to int8 |
|
int82eq(bigint, smallint)
|
postgres |
equal |
|
int82ge(bigint, smallint)
|
postgres |
greater-than-or-equal |
|
int82gt(bigint, smallint)
|
postgres |
greater-than |
|
int82le(bigint, smallint)
|
postgres |
less-than-or-equal |
|
int82lt(bigint, smallint)
|
postgres |
less-than |
|
int82ne(bigint, smallint)
|
postgres |
not equal |
|
int84div(bigint, integer)
|
postgres |
divide |
|
int84eq(bigint, integer)
|
postgres |
equal |
|
int84ge(bigint, integer)
|
postgres |
greater-than-or-equal |
|
int84gt(bigint, integer)
|
postgres |
greater-than |
|
int84le(bigint, integer)
|
postgres |
less-than-or-equal |
|
int84lt(bigint, integer)
|
postgres |
less-than |
|
int84mi(bigint, integer)
|
postgres |
subtract |
|
int84mul(bigint, integer)
|
postgres |
multiply |
|
int84ne(bigint, integer)
|
postgres |
not equal |
|
int84pl(bigint, integer)
|
postgres |
add |
|
int8_accum(bigint)
|
postgres |
aggregate transition function |
|
int8_avg()
|
postgres |
AVG(int) aggregate final function |
|
int8_sum(numeric, bigint)
|
postgres |
SUM(int8) transition function |
|
int8abs(bigint)
|
postgres |
absolute value |
|
int8and(bigint, bigint)
|
postgres |
bitwise and |
|
int8div(bigint, bigint)
|
postgres |
divide |
|
int8eq(bigint, bigint)
|
postgres |
equal |
|
int8ge(bigint, bigint)
|
postgres |
greater-than-or-equal |
|
int8gt(bigint, bigint)
|
postgres |
greater-than |
|
int8in(cstring)
|
postgres |
I/O |
|
int8inc(bigint)
|
postgres |
increment |
|
int8inc_any(bigint, "any")
|
postgres |
increment, ignores second argument |
|
int8inc_float8_float8(bigint, double precision, double precision)
|
postgres |
REGR_COUNT(double, double) transition function |
|
int8larger(bigint, bigint)
|
postgres |
larger of two |
|
int8le(bigint, bigint)
|
postgres |
less-than-or-equal |
|
int8lt(bigint, bigint)
|
postgres |
less-than |
|
int8mi(bigint, bigint)
|
postgres |
subtract |
|
int8mod(bigint, bigint)
|
postgres |
modulus |
|
int8mul(bigint, bigint)
|
postgres |
multiply |
|
int8ne(bigint, bigint)
|
postgres |
not equal |
|
int8not(bigint)
|
postgres |
bitwise not |
|
int8or(bigint, bigint)
|
postgres |
bitwise or |
|
int8out(bigint)
|
postgres |
I/O |
|
int8pl(bigint, bigint)
|
postgres |
add |
|
int8pl_inet(bigint, inet)
|
postgres |
add integer to inet value |
|
int8recv(internal)
|
postgres |
I/O |
|
int8send(bigint)
|
postgres |
I/O |
|
int8shl(bigint, integer)
|
postgres |
bitwise shift left |
|
int8shr(bigint, integer)
|
postgres |
bitwise shift right |
|
int8smaller(bigint, bigint)
|
postgres |
smaller of two |
|
int8um(bigint)
|
postgres |
negate |
|
int8up(bigint)
|
postgres |
unary plus |
|
int8xor(bigint, bigint)
|
postgres |
bitwise xor |
|
integer_pl_date(integer, date)
|
postgres |
|
|
inter_lb(line, box)
|
postgres |
intersect? |
|
inter_sb(lseg, box)
|
postgres |
intersect? |
|
inter_sl(lseg, line)
|
postgres |
intersect? |
|
internal_in(cstring)
|
postgres |
I/O |
|
internal_out(internal)
|
postgres |
I/O |
|
interval(time without time zone)
|
postgres |
convert time to interval |
|
interval(interval, integer)
|
postgres |
adjust interval precision |
|
interval(reltime)
|
postgres |
convert reltime to interval |
|
interval(text)
|
postgres |
convert text to interval |
|
interval_accum(interval)
|
postgres |
aggregate transition function |
|
interval_avg()
|
postgres |
AVG aggregate final function |
|
interval_cmp(interval, interval)
|
postgres |
less-equal-greater |
|
interval_div(interval, double precision)
|
postgres |
divide |
|
interval_eq(interval, interval)
|
postgres |
equal |
|
interval_ge(interval, interval)
|
postgres |
greater-than-or-equal |
|
interval_gt(interval, interval)
|
postgres |
greater-than |
|
interval_hash(interval)
|
postgres |
hash |
|
interval_in(cstring, oid, integer)
|
postgres |
I/O |
|
interval_larger(interval, interval)
|
postgres |
larger of two |
|
interval_le(interval, interval)
|
postgres |
less-than-or-equal |
|
interval_lt(interval, interval)
|
postgres |
less-than |
|
interval_mi(interval, interval)
|
postgres |
subtract |
|
interval_mul(interval, double precision)
|
postgres |
multiply interval |
|
interval_ne(interval, interval)
|
postgres |
not equal |
|
interval_out(interval)
|
postgres |
I/O |
|
interval_pl(interval, interval)
|
postgres |
add |
|
interval_pl_date(interval, date)
|
postgres |
|
|
interval_pl_time(interval, time without time zone)
|
postgres |
plus |
|
interval_pl_timestamp(interval, timestamp without time zone)
|
postgres |
|
|
interval_pl_timestamptz(interval, timestamp with time zone)
|
postgres |
|
|
interval_pl_timetz(interval, time with time zone)
|
postgres |
|
|
interval_recv(internal, oid, integer)
|
postgres |
I/O |
|
interval_send(interval)
|
postgres |
I/O |
|
interval_smaller(interval, interval)
|
postgres |
smaller of two |
|
interval_um(interval)
|
postgres |
subtract |
|
intinterval(abstime, tinterval)
|
postgres |
abstime in tinterval |
|
isclosed(path)
|
postgres |
path closed? |
|
isfalse(boolean)
|
postgres |
bool is false (not true or unknown) |
|
isfinite(timestamp with time zone)
|
postgres |
finite timestamp? |
|
isfinite(abstime)
|
postgres |
finite abstime? |
|
isfinite(interval)
|
postgres |
finite interval? |
|
isfinite(timestamp without time zone)
|
postgres |
finite timestamp? |
|
ishorizontal(line)
|
postgres |
horizontal? |
|
ishorizontal(point, point)
|
postgres |
horizontally aligned? |
|
ishorizontal(lseg)
|
postgres |
horizontal? |
|
isnotfalse(boolean)
|
postgres |
bool is not false (ie, true or unknown) |
|
isnottrue(boolean)
|
postgres |
bool is not true (ie, false or unknown) |
|
iso8859_1_to_utf8(integer, integer, cstring, internal, integer)
|
postgres |
|
|
iso8859_to_utf8(integer, integer, cstring, internal, integer)
|
postgres |
|
|
iso_to_koi8r(integer, integer, cstring, internal, integer)
|
postgres |
|
|
iso_to_mic(integer, integer, cstring, internal, integer)
|
postgres |
|
|
iso_to_win1251(integer, integer, cstring, internal, integer)
|
postgres |
|
|
iso_to_win866(integer, integer, cstring, internal, integer)
|
postgres |
|
|
isopen(path)
|
postgres |
path open? |
|
isparallel(lseg, lseg)
|
postgres |
parallel? |
|
isparallel(line, line)
|
postgres |
parallel? |
|
isperp(lseg, lseg)
|
postgres |
perpendicular? |
|
isperp(line, line)
|
postgres |
perpendicular? |
|
istrue(boolean)
|
postgres |
bool is true (not false or unknown) |
|
isvertical(line)
|
postgres |
vertical? |
|
isvertical(point, point)
|
postgres |
vertically aligned? |
|
isvertical(lseg)
|
postgres |
vertical? |
|
johab_to_utf8(integer, integer, cstring, internal, integer)
|
postgres |
|
|
justify_days(interval)
|
postgres |
promote groups of 30 days to numbers of months |
|
justify_hours(interval)
|
postgres |
promote groups of 24 hours to numbers of days |
|
justify_interval(interval)
|
postgres |
promote groups of 24 hours to numbers of days and promote groups of 30 days to numbers of months |
|
koi8r_to_iso(integer, integer, cstring, internal, integer)
|
postgres |
|
|
koi8r_to_mic(integer, integer, cstring, internal, integer)
|
postgres |
|
|
koi8r_to_utf8(integer, integer, cstring, internal, integer)
|
postgres |
|
|
koi8r_to_win1251(integer, integer, cstring, internal, integer)
|
postgres |
|
|
koi8r_to_win866(integer, integer, cstring, internal, integer)
|
postgres |
|
|
language_handler_in(cstring)
|
postgres |
I/O |
|
language_handler_out(language_handler)
|
postgres |
I/O |
|
lastval()
|
postgres |
current value from last used sequence |
|
latin1_to_mic(integer, integer, cstring, internal, integer)
|
postgres |
|
|
latin2_to_mic(integer, integer, cstring, internal, integer)
|
postgres |
|
|
latin2_to_win1250(integer, integer, cstring, internal, integer)
|
postgres |
|
|
latin3_to_mic(integer, integer, cstring, internal, integer)
|
postgres |
|
|
latin4_to_mic(integer, integer, cstring, internal, integer)
|
postgres |
|
|
length(path)
|
postgres |
sum of path segments |
|
length(character)
|
postgres |
character length |
|
length(text)
|
postgres |
length |
|
length(bytea)
|
postgres |
octet length |
|
length(bit)
|
postgres |
bitstring length |
|
length(lseg)
|
postgres |
distance between endpoints |
|
like(bytea, bytea)
|
postgres |
matches LIKE expression |
|
like(name, text)
|
postgres |
matches LIKE expression |
|
like(text, text)
|
postgres |
matches LIKE expression |
|
like_escape(text, text)
|
postgres |
convert LIKE pattern to use backslash escapes |
|
like_escape(bytea, bytea)
|
postgres |
convert LIKE pattern to use backslash escapes |
|
likejoinsel(internal, oid, internal, smallint)
|
postgres |
join selectivity of LIKE |
|
likesel(internal, oid, internal, integer)
|
postgres |
restriction selectivity of LIKE |
|
line(point, point)
|
postgres |
line from points |
|
line_distance(line, line)
|
postgres |
distance between |
|
line_eq(line, line)
|
postgres |
lines equal? |
|
line_horizontal(line)
|
postgres |
horizontal? |
|
line_in(cstring)
|
postgres |
I/O |
|
line_interpt(line, line)
|
postgres |
intersection point |
|
line_intersect(line, line)
|
postgres |
intersect? |
|
line_out(line)
|
postgres |
I/O |
|
line_parallel(line, line)
|
postgres |
parallel? |
|
line_perp(line, line)
|
postgres |
perpendicular? |
|
line_recv(internal)
|
postgres |
I/O |
|
line_send(line)
|
postgres |
I/O |
|
line_vertical(line)
|
postgres |
vertical? |
|
ln(double precision)
|
postgres |
natural logarithm |
|
ln(numeric)
|
postgres |
natural logarithm of n |
|
lo_close(integer)
|
postgres |
large object close |
|
lo_creat(integer)
|
postgres |
large object create |
|
lo_create(oid)
|
postgres |
large object create |
|
lo_export(oid, text)
|
postgres |
large object export |
|
lo_import(text)
|
postgres |
large object import |
|
lo_lseek(integer, integer, integer)
|
postgres |
large object seek |
|
lo_open(oid, integer)
|
postgres |
large object open |
|
lo_tell(integer)
|
postgres |
large object position |
|
lo_unlink(oid)
|
postgres |
large object unlink(delete) |
|
log(numeric)
|
postgres |
logarithm base 10 of n |
|
log(numeric, numeric)
|
postgres |
logarithm base m of n |
|
log(double precision)
|
postgres |
base 10 logarithm |
|
loread(integer, integer)
|
postgres |
large object read |
|
lower(text)
|
postgres |
lowercase |
|
lowrite(integer, bytea)
|
postgres |
large object write |
|
lpad(text, integer)
|
postgres |
left-pad string to length |
|
lpad(text, integer, text)
|
postgres |
left-pad string to length |
|
lseg(point, point)
|
postgres |
convert points to line segment |
|
lseg(box)
|
postgres |
diagonal of |
|
lseg_center(lseg)
|
postgres |
center of |
|
lseg_distance(lseg, lseg)
|
postgres |
distance between |
|
lseg_eq(lseg, lseg)
|
postgres |
equal |
|
lseg_ge(lseg, lseg)
|
postgres |
greater-than-or-equal by length |
|
lseg_gt(lseg, lseg)
|
postgres |
greater-than by length |
|
lseg_horizontal(lseg)
|
postgres |
horizontal? |
|
lseg_in(cstring)
|
postgres |
I/O |
|
lseg_interpt(lseg, lseg)
|
postgres |
intersection point |
|
lseg_intersect(lseg, lseg)
|
postgres |
intersect? |
|
lseg_le(lseg, lseg)
|
postgres |
less-than-or-equal by length |
|
lseg_length(lseg)
|
postgres |
distance between endpoints |
|
lseg_lt(lseg, lseg)
|
postgres |
less-than by length |
|
lseg_ne(lseg, lseg)
|
postgres |
not equal |
|
lseg_out(lseg)
|
postgres |
I/O |
|
lseg_parallel(lseg, lseg)
|
postgres |
parallel? |
|
lseg_perp(lseg, lseg)
|
postgres |
perpendicular? |
|
lseg_recv(internal)
|
postgres |
I/O |
|
lseg_send(lseg)
|
postgres |
I/O |
|
lseg_vertical(lseg)
|
postgres |
vertical? |
|
ltrim(text)
|
postgres |
trim spaces from left end of string |
|
ltrim(text, text)
|
postgres |
trim selected characters from left end of string |
|
macaddr(text)
|
postgres |
text to MAC address |
|
macaddr_cmp(macaddr, macaddr)
|
postgres |
less-equal-greater |
|
macaddr_eq(macaddr, macaddr)
|
postgres |
equal |
|
macaddr_ge(macaddr, macaddr)
|
postgres |
greater-than-or-equal |
|
macaddr_gt(macaddr, macaddr)
|
postgres |
greater-than |
|
macaddr_in(cstring)
|
postgres |
I/O |
|
macaddr_le(macaddr, macaddr)
|
postgres |
less-than-or-equal |
|
macaddr_lt(macaddr, macaddr)
|
postgres |
less-than |
|
macaddr_ne(macaddr, macaddr)
|
postgres |
not equal |
|
macaddr_out(macaddr)
|
postgres |
I/O |
|
macaddr_recv(internal)
|
postgres |
I/O |
|
macaddr_send(macaddr)
|
postgres |
I/O |
|
makeaclitem(oid, oid, text, boolean)
|
postgres |
make ACL item |
|
masklen(inet)
|
postgres |
netmask length |
|
md5(bytea)
|
postgres |
calculates md5 hash |
|
md5(text)
|
postgres |
calculates md5 hash |
|
mic_to_ascii(integer, integer, cstring, internal, integer)
|
postgres |
|
|
mic_to_big5(integer, integer, cstring, internal, integer)
|
postgres |
|
|
mic_to_euc_cn(integer, integer, cstring, internal, integer)
|
postgres |
|
|
mic_to_euc_jp(integer, integer, cstring, internal, integer)
|
postgres |
|
|
mic_to_euc_kr(integer, integer, cstring, internal, integer)
|
postgres |
|
|
mic_to_euc_tw(integer, integer, cstring, internal, integer)
|
postgres |
|
|
mic_to_iso(integer, integer, cstring, internal, integer)
|
postgres |
|
|
mic_to_koi8r(integer, integer, cstring, internal, integer)
|
postgres |
|
|
mic_to_latin1(integer, integer, cstring, internal, integer)
|
postgres |
|
|
mic_to_latin2(integer, integer, cstring, internal, integer)
|
postgres |
|
|
mic_to_latin3(integer, integer, cstring, internal, integer)
|
postgres |
|
|
mic_to_latin4(integer, integer, cstring, internal, integer)
|
postgres |
|
|
mic_to_sjis(integer, integer, cstring, internal, integer)
|
postgres |
|
|
mic_to_win1250(integer, integer, cstring, internal, integer)
|
postgres |
|
|
mic_to_win1251(integer, integer, cstring, internal, integer)
|
postgres |
|
|
mic_to_win866(integer, integer, cstring, internal, integer)
|
postgres |
|
|
mktinterval(abstime, abstime)
|
postgres |
convert to tinterval |
|
mod(integer, integer)
|
postgres |
modulus |
|
mod(smallint, smallint)
|
postgres |
modulus |
|
mod(smallint, integer)
|
postgres |
modulus |
|
mod(numeric, numeric)
|
postgres |
modulus |
|
mod(integer, smallint)
|
postgres |
modulus |
|
mod(bigint, bigint)
|
postgres |
modulus |
|
mul_d_interval(double precision, interval)
|
postgres |
|
|
name(character varying)
|
postgres |
convert varchar to name |
|
name(character)
|
postgres |
convert char(n) to name |
|
name(text)
|
postgres |
convert text to name |
|
name_pattern_eq(name, name)
|
postgres |
|
|
name_pattern_ge(name, name)
|
postgres |
|
|
name_pattern_gt(name, name)
|
postgres |
|
|
name_pattern_le(name, name)
|
postgres |
|
|
name_pattern_lt(name, name)
|
postgres |
|
|
name_pattern_ne(name, name)
|
postgres |
|
|
nameeq(name, name)
|
postgres |
equal |
|
namege(name, name)
|
postgres |
greater-than-or-equal |
|
namegt(name, name)
|
postgres |
greater-than |
|
nameiclike(name, text)
|
postgres |
matches LIKE expression, case-insensitive |
|
nameicnlike(name, text)
|
postgres |
does not match LIKE expression, case-insensitive |
|
nameicregexeq(name, text)
|
postgres |
matches regex., case-insensitive |
|
nameicregexne(name, text)
|
postgres |
does not match regex., case-insensitive |
|
namein(cstring)
|
postgres |
I/O |
|
namele(name, name)
|
postgres |
less-than-or-equal |
|
namelike(name, text)
|
postgres |
matches LIKE expression |
|
namelt(name, name)
|
postgres |
less-than |
|
namene(name, name)
|
postgres |
not equal |
|
namenlike(name, text)
|
postgres |
does not match LIKE expression |
|
nameout(name)
|
postgres |
I/O |
|
namerecv(internal)
|
postgres |
I/O |
|
nameregexeq(name, text)
|
postgres |
matches regex., case-sensitive |
|
nameregexne(name, text)
|
postgres |
does not match regex., case-sensitive |
|
namesend(name)
|
postgres |
I/O |
|
neqjoinsel(internal, oid, internal, smallint)
|
postgres |
join selectivity of <> and related operators |
|
neqsel(internal, oid, internal, integer)
|
postgres |
restriction selectivity of <> and related operators |
|
netmask(inet)
|
postgres |
netmask of address |
|
network(inet)
|
postgres |
network part of address |
|
network_cmp(inet, inet)
|
postgres |
less-equal-greater |
|
network_eq(inet, inet)
|
postgres |
equal |
|
network_ge(inet, inet)
|
postgres |
greater-than-or-equal |
|
network_gt(inet, inet)
|
postgres |
greater-than |
|
network_le(inet, inet)
|
postgres |
less-than-or-equal |
|
network_lt(inet, inet)
|
postgres |
less-than |
|
network_ne(inet, inet)
|
postgres |
not equal |
|
network_sub(inet, inet)
|
postgres |
is-subnet |
|
network_subeq(inet, inet)
|
postgres |
is-subnet-or-equal |
|
network_sup(inet, inet)
|
postgres |
is-supernet |
|
network_supeq(inet, inet)
|
postgres |
is-supernet-or-equal |
|
nextval(regclass)
|
postgres |
sequence next value |
|
nlikejoinsel(internal, oid, internal, smallint)
|
postgres |
join selectivity of NOT LIKE |
|
nlikesel(internal, oid, internal, integer)
|
postgres |
restriction selectivity of NOT LIKE |
|
nonnullvalue("any")
|
postgres |
(internal) |
|
notlike(name, text)
|
postgres |
does not match LIKE expression |
|
notlike(text, text)
|
postgres |
does not match LIKE expression |
|
notlike(bytea, bytea)
|
postgres |
does not match LIKE expression |
|
now()
|
postgres |
current transaction time |
|
npoints(polygon)
|
postgres |
number of points in polygon |
|
npoints(path)
|
postgres |
number of points in path |
|
nullvalue("any")
|
postgres |
(internal) |
|
numeric(smallint)
|
postgres |
(internal) |
|
numeric(text)
|
postgres |
(internal) |
|
numeric(numeric, integer)
|
postgres |
adjust numeric to typmod precision/scale |
|
numeric(integer)
|
postgres |
(internal) |
|
numeric(real)
|
postgres |
(internal) |
|
numeric(double precision)
|
postgres |
(internal) |
|
numeric(bigint)
|
postgres |
(internal) |
|
numeric_abs(numeric)
|
postgres |
absolute value |
|
numeric_accum(numeric)
|
postgres |
aggregate transition function |
|
numeric_add(numeric, numeric)
|
postgres |
add |
|
numeric_avg()
|
postgres |
AVG aggregate final function |
|
numeric_cmp(numeric, numeric)
|
postgres |
compare two numbers |
|
numeric_div(numeric, numeric)
|
postgres |
divide |
|
numeric_eq(numeric, numeric)
|
postgres |
equal |
|
numeric_exp(numeric)
|
postgres |
e raised to the power of n |
|
numeric_fac(bigint)
|
postgres |
|
|
numeric_ge(numeric, numeric)
|
postgres |
greater-than-or-equal |
|
numeric_gt(numeric, numeric)
|
postgres |
greater-than |
|
numeric_in(cstring, oid, integer)
|
postgres |
I/O |
|
numeric_inc(numeric)
|
postgres |
increment by one |
|
numeric_larger(numeric, numeric)
|
postgres |
larger of two numbers |
|
numeric_le(numeric, numeric)
|
postgres |
less-than-or-equal |
|
numeric_ln(numeric)
|
postgres |
natural logarithm of n |
|
numeric_log(numeric, numeric)
|
postgres |
logarithm base m of n |
|
numeric_lt(numeric, numeric)
|
postgres |
less-than |
|
numeric_mod(numeric, numeric)
|
postgres |
modulus |
|
numeric_mul(numeric, numeric)
|
postgres |
multiply |
|
numeric_ne(numeric, numeric)
|
postgres |
not equal |
|
numeric_out(numeric)
|
postgres |
I/O |
|
numeric_power(numeric, numeric)
|
postgres |
m raised to the power of n |
|
numeric_recv(internal, oid, integer)
|
postgres |
I/O |
|
numeric_send(numeric)
|
postgres |
I/O |
|
numeric_smaller(numeric, numeric)
|
postgres |
smaller of two numbers |
|
numeric_sqrt(numeric)
|
postgres |
square root |
|
numeric_stddev_pop()
|
postgres |
STDDEV_POP aggregate final function |
|
numeric_stddev_samp()
|
postgres |
STDDEV_SAMP aggregate final function |
|
numeric_sub(numeric, numeric)
|
postgres |
subtract |
|
numeric_uminus(numeric)
|
postgres |
negate |
|
numeric_uplus(numeric)
|
postgres |
unary plus |
|
numeric_var_pop()
|
postgres |
VAR_POP aggregate final function |
|
numeric_var_samp()
|
postgres |
VAR_SAMP aggregate final function |
|
obj_description(oid)
|
postgres |
get description for object id (deprecated) |
|
obj_description(oid, name)
|
postgres |
get description for object id and catalog name |
|
octet_length(bytea)
|
postgres |
octet length |
|
octet_length(character)
|
postgres |
octet length |
|
octet_length(text)
|
postgres |
octet length |
|
octet_length(bit)
|
postgres |
octet length |
|
oid(bigint)
|
postgres |
convert int8 to oid |
|
oid(text)
|
postgres |
convert text to oid |
|
oideq(oid, oid)
|
postgres |
equal |
|
oidge(oid, oid)
|
postgres |
greater-than-or-equal |
|
oidgt(oid, oid)
|
postgres |
greater-than |
|
oidin(cstring)
|
postgres |
I/O |
|
oidlarger(oid, oid)
|
postgres |
larger of two |
|
oidle(oid, oid)
|
postgres |
less-than-or-equal |
|
oidlt(oid, oid)
|
postgres |
less-than |
|
oidne(oid, oid)
|
postgres |
not equal |
|
oidnotin(oid, text)
|
postgres |
not in |
|
oidout(oid)
|
postgres |
I/O |
|
oidrecv(internal)
|
postgres |
I/O |
|
oidsend(oid)
|
postgres |
I/O |
|
oidsmaller(oid, oid)
|
postgres |
smaller of two |
|
oidvectoreq(oidvector, oidvector)
|
postgres |
equal |
|
oidvectorge(oidvector, oidvector)
|
postgres |
greater-than-or-equal |
|
oidvectorgt(oidvector, oidvector)
|
postgres |
greater-than |
|
oidvectorin(cstring)
|
postgres |
I/O |
|
oidvectorle(oidvector, oidvector)
|
postgres |
less-than-or-equal |
|
oidvectorlt(oidvector, oidvector)
|
postgres |
less-than |
|
oidvectorne(oidvector, oidvector)
|
postgres |
not equal |
|
oidvectorout(oidvector)
|
postgres |
I/O |
|
oidvectorrecv(internal)
|
postgres |
I/O |
|
oidvectorsend(oidvector)
|
postgres |
I/O |
|
oidvectortypes(oidvector)
|
postgres |
print type names of oidvector field |
|
on_pb(point, box)
|
postgres |
point inside box? |
|
on_pl(point, line)
|
postgres |
point on line? |
|
on_ppath(point, path)
|
postgres |
point within closed path, or point on open path |
|
on_ps(point, lseg)
|
postgres |
point contained in segment? |
|
on_sb(lseg, box)
|
postgres |
lseg contained in box? |
|
on_sl(lseg, line)
|
postgres |
lseg on line? |
|
opaque_in(cstring)
|
postgres |
I/O |
|
opaque_out(opaque)
|
postgres |
I/O |
|
overlaps(timestamp with time zone, timestamp with time zone, timestamp with time zone, timestamp with time zone)
|
postgres |
SQL92 interval comparison |
|
overlaps(time without time zone, time without time zone, time without time zone, time without time zone)
|
postgres |
SQL92 interval comparison |
|
overlaps(time without time zone, interval, time without time zone, interval)
|
postgres |
SQL92 interval comparison |
|
overlaps(time without time zone, time without time zone, time without time zone, interval)
|
postgres |
SQL92 interval comparison |
|
overlaps(time without time zone, interval, time without time zone, time without time zone)
|
postgres |
SQL92 interval comparison |
|
overlaps(time with time zone, time with time zone, time with time zone, time with time zone)
|
postgres |
SQL92 interval comparison |
|
overlaps(timestamp without time zone, interval, timestamp without time zone, timestamp without time zone)
|
postgres |
SQL92 interval comparison |
|
overlaps(timestamp without time zone, timestamp without time zone, timestamp without time zone, interval)
|
postgres |
SQL92 interval comparison |
|
overlaps(timestamp without time zone, interval, timestamp without time zone, interval)
|
postgres |
SQL92 interval comparison |
|
overlaps(timestamp with time zone, interval, timestamp with time zone, interval)
|
postgres |
SQL92 interval comparison |
|
overlaps(timestamp with time zone, timestamp with time zone, timestamp with time zone, interval)
|
postgres |
SQL92 interval comparison |
|
overlaps(timestamp without time zone, timestamp without time zone, timestamp without time zone, timestamp without time zone)
|
postgres |
SQL92 interval comparison |
|
overlaps(timestamp with time zone, interval, timestamp with time zone, timestamp with time zone)
|
postgres |
SQL92 interval comparison |
|
overlay(text, text, integer)
|
postgres |
substitute portion of string |
|
overlay(text, text, integer, integer)
|
postgres |
substitute portion of string |
|
path(polygon)
|
postgres |
convert polygon to path |
|
path_add(path, path)
|
postgres |
concatenate open paths |
|
path_add_pt(path, point)
|
postgres |
add (translate path) |
|
path_center(path)
|
postgres |
center of |
|
path_contain_pt(path, point)
|
postgres |
path contains point? |
|
path_distance(path, path)
|
postgres |
distance between paths |
|
path_div_pt(path, point)
|
postgres |
divide (rotate/scale path) |
|
path_in(cstring)
|
postgres |
I/O |
|
path_inter(path, path)
|
postgres |
intersect? |
|
path_length(path)
|
postgres |
sum of path segment lengths |
|
path_mul_pt(path, point)
|
postgres |
multiply (rotate/scale path) |
|
path_n_eq(path, path)
|
postgres |
equal |
|
path_n_ge(path, path)
|
postgres |
greater-than-or-equal |
|
path_n_gt(path, path)
|
postgres |
greater-than |
|
path_n_le(path, path)
|
postgres |
less-than-or-equal |
|
path_n_lt(path, path)
|
postgres |
less-than |
|
path_npoints(path)
|
postgres |
number of points in path |
|
path_out(path)
|
postgres |
I/O |
|
path_recv(internal)
|
postgres |
I/O |
|
path_send(path)
|
postgres |
I/O |
|
path_sub_pt(path, point)
|
postgres |
subtract (translate path) |
|
pclose(path)
|
postgres |
close path |
|
pg_advisory_lock(bigint)
|
postgres |
obtain exclusive advisory lock |
|
pg_advisory_lock(integer, integer)
|
postgres |
obtain exclusive advisory lock |
|
pg_advisory_lock_shared(bigint)
|
postgres |
obtain shared advisory lock |
|
pg_advisory_lock_shared(integer, integer)
|
postgres |
obtain shared advisory lock |
|
pg_advisory_unlock(integer, integer)
|
postgres |
release exclusive advisory lock |
|
pg_advisory_unlock(bigint)
|
postgres |
release exclusive advisory lock |
|
pg_advisory_unlock_all()
|
postgres |
release all advisory locks |
|
pg_advisory_unlock_shared(bigint)
|
postgres |
release shared advisory lock |
|
pg_advisory_unlock_shared(integer, integer)
|
postgres |
release shared advisory lock |
|
pg_backend_pid()
|
postgres |
Statistics: Current backend PID |
|
pg_cancel_backend(integer)
|
postgres |
Cancel a server process' current query |
|
pg_char_to_encoding(name)
|
postgres |
convert encoding name to encoding id |
|
pg_client_encoding()
|
postgres |
encoding name of current database |
|
pg_column_size("any")
|
postgres |
bytes required to store the value, perhaps with compression |
|
pg_conversion_is_visible(oid)
|
postgres |
is conversion visible in search path? |
|
pg_current_xlog_insert_location()
|
postgres |
current xlog insert location |
|
pg_current_xlog_location()
|
postgres |
current xlog write location |
|
pg_cursor()
|
postgres |
get the open cursors for this session |
|
pg_database_size(name)
|
postgres |
Calculate total disk space usage for the specified database |
|
pg_database_size(oid)
|
postgres |
Calculate total disk space usage for the specified database |
|
pg_encoding_to_char(integer)
|
postgres |
convert encoding id to encoding name |
|
pg_file_length(text)
|
postgres |
|
|
pg_file_read(text, bigint, bigint)
|
postgres |
|
|
pg_file_rename(text, text, text)
|
postgres |
|
|
pg_file_rename(text, text)
|
postgres |
|
|
pg_file_unlink(text)
|
postgres |
|
|
pg_file_write(text, text, boolean)
|
postgres |
|
|
pg_function_is_visible(oid)
|
postgres |
is function visible in search path? |
|
pg_get_constraintdef(oid)
|
postgres |
constraint description |
|
pg_get_constraintdef(oid, boolean)
|
postgres |
constraint description with pretty-print option |
|
pg_get_expr(text, oid)
|
postgres |
deparse an encoded expression |
|
pg_get_expr(text, oid, boolean)
|
postgres |
deparse an encoded expression with pretty-print option |
|
pg_get_indexdef(oid)
|
postgres |
index description |
|
pg_get_indexdef(oid, integer, boolean)
|
postgres |
index description (full create statement or single expression) with pretty-print option |
|
pg_get_ruledef(oid)
|
postgres |
source text of a rule |
|
pg_get_ruledef(oid, boolean)
|
postgres |
source text of a rule with pretty-print option |
|
pg_get_serial_sequence(text, text)
|
postgres |
name of sequence for a serial column |
|
pg_get_triggerdef(oid)
|
postgres |
trigger description |
|
pg_get_userbyid(oid)
|
postgres |
role name by OID (with fallback) |
|
pg_get_viewdef(text, boolean)
|
postgres |
select statement of a view with pretty-print option |
|
pg_get_viewdef(text)
|
postgres |
select statement of a view |
|
pg_get_viewdef(oid)
|
postgres |
select statement of a view |
|
pg_get_viewdef(oid, boolean)
|
postgres |
select statement of a view with pretty-print option |
|
pg_has_role(oid, name, text)
|
postgres |
user privilege on role by user oid, role name |
|
pg_has_role(oid, text)
|
postgres |
current user privilege on role by role oid |
|
pg_has_role(name, text)
|
postgres |
current user privilege on role by role name |
|
pg_has_role(oid, oid, text)
|
postgres |
user privilege on role by user oid, role oid |
|
pg_has_role(name, oid, text)
|
postgres |
user privilege on role by username, role oid |
|
pg_has_role(name, name, text)
|
postgres |
user privilege on role by username, role name |
|
pg_is_other_temp_schema(oid)
|
postgres |
is schema another session's temp schema? |
|
pg_lock_status()
|
postgres |
view system lock information |
|
pg_logdir_ls()
|
postgres |
|
|
pg_logfile_rotate()
|
postgres |
|
|
pg_ls_dir(text)
|
postgres |
List all files in a directory |
|
pg_my_temp_schema()
|
postgres |
get OID of current session's temp schema, if any |
|
pg_opclass_is_visible(oid)
|
postgres |
is opclass visible in search path? |
|
pg_operator_is_visible(oid)
|
postgres |
is operator visible in search path? |
|
pg_postmaster_start_time()
|
postgres |
postmaster start time |
|
pg_prepared_statement()
|
postgres |
get the prepared statements for this session |
|
pg_prepared_xact()
|
postgres |
view two-phase transactions |
|
pg_read_file(text, bigint, bigint)
|
postgres |
Read text from a file |
|
pg_relation_size(text)
|
postgres |
Calculate disk space usage for the specified table or index |
|
pg_relation_size(oid)
|
postgres |
Calculate disk space usage for the specified table or index |
|
pg_reload_conf()
|
postgres |
Reload configuration files |
|
pg_rotate_logfile()
|
postgres |
Rotate log file |
|
pg_show_all_settings()
|
postgres |
SHOW ALL as a function |
|
pg_size_pretty(bigint)
|
postgres |
Convert a long int to a human readable text using size units |
|
pg_sleep(double precision)
|
postgres |
Sleep for the specified time in seconds |
|
pg_start_backup(text)
|
postgres |
Prepare for taking an online backup |
|
pg_stat_get_backend_activity(integer)
|
postgres |
Statistics: Current query of backend |
|
pg_stat_get_backend_activity_start(integer)
|
postgres |
Statistics: Start time for current query of backend |
|
pg_stat_get_backend_client_addr(integer)
|
postgres |
Statistics: Address of client connected to backend |
|
pg_stat_get_backend_client_port(integer)
|
postgres |
Statistics: Port number of client connected to backend |
|
pg_stat_get_backend_dbid(integer)
|
postgres |
Statistics: Database ID of backend |
|
pg_stat_get_backend_idset()
|
postgres |
Statistics: Currently active backend IDs |
|
pg_stat_get_backend_pid(integer)
|
postgres |
Statistics: PID of backend |
|
pg_stat_get_backend_start(integer)
|
postgres |
Statistics: Start time for current backend session |
|
pg_stat_get_backend_userid(integer)
|
postgres |
Statistics: User ID of backend |
|
pg_stat_get_backend_waiting(integer)
|
postgres |
Statistics: Is backend currently waiting for a lock |
|
pg_stat_get_blocks_fetched(oid)
|
postgres |
Statistics: Number of blocks fetched |
|
pg_stat_get_blocks_hit(oid)
|
postgres |
Statistics: Number of blocks found in cache |
|
pg_stat_get_db_blocks_fetched(oid)
|
postgres |
Statistics: Blocks fetched for database |
|
pg_stat_get_db_blocks_hit(oid)
|
postgres |
Statistics: Blocks found in cache for database |
|
pg_stat_get_db_numbackends(oid)
|
postgres |
Statistics: Number of backends in database |
|
pg_stat_get_db_xact_commit(oid)
|
postgres |
Statistics: Transactions committed |
|
pg_stat_get_db_xact_rollback(oid)
|
postgres |
Statistics: Transactions rolled back |
|
pg_stat_get_last_analyze_time(oid)
|
postgres |
Statistics: Last manual analyze time for a table |
|
pg_stat_get_last_autoanalyze_time(oid)
|
postgres |
Statistics: Last auto analyze time for a table |
|
pg_stat_get_last_autovacuum_time(oid)
|
postgres |
Statistics: Last auto vacuum time for a table |
|
pg_stat_get_last_vacuum_time(oid)
|
postgres |
Statistics: Last manual vacuum time for a table |
|
pg_stat_get_numscans(oid)
|
postgres |
Statistics: Number of scans done for table/index |
|
pg_stat_get_tuples_deleted(oid)
|
postgres |
Statistics: Number of tuples deleted |
|
pg_stat_get_tuples_fetched(oid)
|
postgres |
Statistics: Number of tuples fetched by idxscan |
|
pg_stat_get_tuples_inserted(oid)
|
postgres |
Statistics: Number of tuples inserted |
|
pg_stat_get_tuples_returned(oid)
|
postgres |
Statistics: Number of tuples read by seqscan |
|
pg_stat_get_tuples_updated(oid)
|
postgres |
Statistics: Number of tuples updated |
|
pg_stat_reset()
|
postgres |
Statistics: Reset collected statistics |
|
pg_stop_backup()
|
postgres |
Finish taking an online backup |
|
pg_switch_xlog()
|
postgres |
Switch to new xlog file |
|
pg_table_is_visible(oid)
|
postgres |
is table visible in search path? |
|
pg_tablespace_databases(oid)
|
postgres |
returns database oids in a tablespace |
|
pg_tablespace_size(name)
|
postgres |
Calculate total disk space usage for the specified tablespace |
|
pg_tablespace_size(oid)
|
postgres |
Calculate total disk space usage for the specified tablespace |
|
pg_total_relation_size(text)
|
postgres |
Calculate total disk space usage for the specified table and associated indexes and toast tables |
|
pg_total_relation_size(oid)
|
postgres |
Calculate total disk space usage for the specified table and associated indexes and toast tables |
|
pg_try_advisory_lock(integer, integer)
|
postgres |
obtain exclusive advisory lock if available |
|
pg_try_advisory_lock(bigint)
|
postgres |
obtain exclusive advisory lock if available |
|
pg_try_advisory_lock_shared(integer, integer)
|
postgres |
obtain shared advisory lock if available |
|
pg_try_advisory_lock_shared(bigint)
|
postgres |
obtain shared advisory lock if available |
|
pg_type_is_visible(oid)
|
postgres |
is type visible in search path? |
|
pg_xlogfile_name(text)
|
postgres |
xlog filename, given an xlog location |
|
pi()
|
postgres |
PI |
|
point(lseg)
|
postgres |
center of |
|
point(double precision, double precision)
|
postgres |
convert x, y to point |
|
point(circle)
|
postgres |
center of |
|
point(box)
|
postgres |
center of |
|
point(path)
|
postgres |
center of |
|
point(polygon)
|
postgres |
center of |
|
point_above(point, point)
|
postgres |
is above |
|
point_add(point, point)
|
postgres |
add points (translate) |
|
point_below(point, point)
|
postgres |
is below |
|
point_distance(point, point)
|
postgres |
distance between |
|
point_div(point, point)
|
postgres |
divide points (scale/rotate) |
|
point_eq(point, point)
|
postgres |
same as? |
|
point_horiz(point, point)
|
postgres |
horizontally aligned? |
|
point_in(cstring)
|
postgres |
I/O |
|
point_left(point, point)
|
postgres |
is left of |
|
point_mul(point, point)
|
postgres |
multiply points (scale/rotate) |
|
point_ne(point, point)
|
postgres |
not equal |
|
point_out(point)
|
postgres |
I/O |
|
point_recv(internal)
|
postgres |
I/O |
|
point_right(point, point)
|
postgres |
is right of |
|
point_send(point)
|
postgres |
I/O |
|
point_sub(point, point)
|
postgres |
subtract points (translate) |
|
point_vert(point, point)
|
postgres |
vertically aligned? |
|
poly_above(polygon, polygon)
|
postgres |
is above |
|
poly_below(polygon, polygon)
|
postgres |
is below |
|
poly_center(polygon)
|
postgres |
center of |
|
poly_contain(polygon, polygon)
|
postgres |
contains? |
|
poly_contain_pt(polygon, point)
|
postgres |
polygon contains point? |
|
poly_contained(polygon, polygon)
|
postgres |
is contained by? |
|
poly_distance(polygon, polygon)
|
postgres |
distance between |
|
poly_in(cstring)
|
postgres |
I/O |
|
poly_left(polygon, polygon)
|
postgres |
is left of |
|
poly_npoints(polygon)
|
postgres |
number of points in polygon |
|
poly_out(polygon)
|
postgres |
I/O |
|
poly_overabove(polygon, polygon)
|
postgres |
overlaps or is above |
|
poly_overbelow(polygon, polygon)
|
postgres |
overlaps or is below |
|
poly_overlap(polygon, polygon)
|
postgres |
overlaps |
|
poly_overleft(polygon, polygon)
|
postgres |
overlaps or is left of |
|
poly_overright(polygon, polygon)
|
postgres |
overlaps or is right of |
|
poly_recv(internal)
|
postgres |
I/O |
|
poly_right(polygon, polygon)
|
postgres |
is right of |
|
poly_same(polygon, polygon)
|
postgres |
same as? |
|
poly_send(polygon)
|
postgres |
I/O |
|
polygon(path)
|
postgres |
convert path to polygon |
|
polygon(circle)
|
postgres |
convert circle to 12-vertex polygon |
|
polygon(box)
|
postgres |
convert box to polygon |
|
polygon(integer, circle)
|
postgres |
convert vertex count and circle to polygon |
|
popen(path)
|
postgres |
open path |
|
position(bit, bit)
|
postgres |
return position of sub-bitstring |
|
position(bytea, bytea)
|
postgres |
return position of substring |
|
position(text, text)
|
postgres |
return position of substring |
|
positionjoinsel(internal, oid, internal, smallint)
|
postgres |
join selectivity for position-comparison operators |
|
positionsel(internal, oid, internal, integer)
|
postgres |
restriction selectivity for position-comparison operators |
|
pow(double precision, double precision)
|
postgres |
exponentiation |
|
pow(numeric, numeric)
|
postgres |
m raised to the power of n |
|
power(numeric, numeric)
|
postgres |
m raised to the power of n |
|
power(double precision, double precision)
|
postgres |
exponentiation |
|
pt_contained_circle(point, circle)
|
postgres |
point contained in circle? |
|
pt_contained_poly(point, polygon)
|
postgres |
point contained in polygon? |
|
quote_ident(text)
|
postgres |
quote an identifier for usage in a querystring |
|
quote_literal(text)
|
postgres |
quote a literal for usage in a querystring |
|
radians(double precision)
|
postgres |
degrees to radians |
|
radius(circle)
|
postgres |
radius of circle |
|
random()
|
postgres |
random value |
|
record_in(cstring, oid, integer)
|
postgres |
I/O |
|
record_out(record)
|
postgres |
I/O |
|
record_recv(internal, oid, integer)
|
postgres |
I/O |
|
record_send(record)
|
postgres |
I/O |
|
regclass(text)
|
postgres |
convert text to regclass |
|
regclassin(cstring)
|
postgres |
I/O |
|
regclassout(regclass)
|
postgres |
I/O |
|
regclassrecv(internal)
|
postgres |
I/O |
|
regclasssend(regclass)
|
postgres |
I/O |
|
regexeqjoinsel(internal, oid, internal, smallint)
|
postgres |
join selectivity of regex match |
|
regexeqsel(internal, oid, internal, integer)
|
postgres |
restriction selectivity of regex match |
|
regexnejoinsel(internal, oid, internal, smallint)
|
postgres |
join selectivity of regex non-match |
|
regexnesel(internal, oid, internal, integer)
|
postgres |
restriction selectivity of regex non-match |
|
regexp_replace(text, text, text)
|
postgres |
replace text using regexp |
|
regexp_replace(text, text, text, text)
|
postgres |
replace text using regexp |
|
regoperatorin(cstring)
|
postgres |
I/O |
|
regoperatorout(regoperator)
|
postgres |
I/O |
|
regoperatorrecv(internal)
|
postgres |
I/O |
|
regoperatorsend(regoperator)
|
postgres |
I/O |
|
regoperin(cstring)
|
postgres |
I/O |
|
regoperout(regoper)
|
postgres |
I/O |
|
regoperrecv(internal)
|
postgres |
I/O |
|
regopersend(regoper)
|
postgres |
I/O |
|
regprocedurein(cstring)
|
postgres |
I/O |
|
regprocedureout(regprocedure)
|
postgres |
I/O |
|
regprocedurerecv(internal)
|
postgres |
I/O |
|
regproceduresend(regprocedure)
|
postgres |
I/O |
|
regprocin(cstring)
|
postgres |
I/O |
|
regprocout(regproc)
|
postgres |
I/O |
|
regprocrecv(internal)
|
postgres |
I/O |
|
regprocsend(regproc)
|
postgres |
I/O |
|
regtypein(cstring)
|
postgres |
I/O |
|
regtypeout(regtype)
|
postgres |
I/O |
|
regtyperecv(internal)
|
postgres |
I/O |
|
regtypesend(regtype)
|
postgres |
I/O |
|
reltime(interval)
|
postgres |
convert interval to reltime |
|
reltimeeq(reltime, reltime)
|
postgres |
equal |
|
reltimege(reltime, reltime)
|
postgres |
greater-than-or-equal |
|
reltimegt(reltime, reltime)
|
postgres |
greater-than |
|
reltimein(cstring)
|
postgres |
I/O |
|
reltimele(reltime, reltime)
|
postgres |
less-than-or-equal |
|
reltimelt(reltime, reltime)
|
postgres |
less-than |
|
reltimene(reltime, reltime)
|
postgres |
not equal |
|
reltimeout(reltime)
|
postgres |
I/O |
|
reltimerecv(internal)
|
postgres |
I/O |
|
reltimesend(reltime)
|
postgres |
I/O |
|
repeat(text, integer)
|
postgres |
replicate string int4 times |
|
replace(text, text, text)
|
postgres |
replace all occurrences of old_substr with new_substr in string |
|
round(double precision)
|
postgres |
round to nearest integer |
|
round(numeric)
|
postgres |
value rounded to 'scale' of zero |
|
round(numeric, integer)
|
postgres |
value rounded to 'scale' |
|
rpad(text, integer)
|
postgres |
right-pad string to length |
|
rpad(text, integer, text)
|
postgres |
right-pad string to length |
|
rtrim(text)
|
postgres |
trim spaces from right end of string |
|
rtrim(text, text)
|
postgres |
trim selected characters from right end of string |
|
scalargtjoinsel(internal, oid, internal, smallint)
|
postgres |
join selectivity of > and related operators on scalar datatypes |
|
scalargtsel(internal, oid, internal, integer)
|
postgres |
restriction selectivity of > and related operators on scalar datatypes |
|
scalarltjoinsel(internal, oid, internal, smallint)
|
postgres |
join selectivity of < and related operators on scalar datatypes |
|
scalarltsel(internal, oid, internal, integer)
|
postgres |
restriction selectivity of < and related operators on scalar datatypes |
|
session_user()
|
postgres |
session user name |
|
set_bit(bytea, integer, integer)
|
postgres |
set bit |
|
set_byte(bytea, integer, integer)
|
postgres |
set byte |
|
set_config(text, text, boolean)
|
postgres |
SET X as a function |
|
set_masklen(inet, integer)
|
postgres |
change netmask of inet |
|
set_masklen(cidr, integer)
|
postgres |
change netmask of cidr |
|
setseed(double precision)
|
postgres |
set random seed |
|
setval(regclass, bigint)
|
postgres |
set sequence value |
|
setval(regclass, bigint, boolean)
|
postgres |
set sequence value and iscalled status |
|
shell_in(cstring)
|
postgres |
I/O |
|
shell_out(opaque)
|
postgres |
I/O |
|
shobj_description(oid, name)
|
postgres |
get description for object id and shared catalog name |
|
sign(numeric)
|
postgres |
sign of value |
|
sign(double precision)
|
postgres |
sign of value |
|
similar_escape(text, text)
|
postgres |
convert SQL99 regexp pattern to POSIX style |
|
sin(double precision)
|
postgres |
sine |
|
sjis_to_euc_jp(integer, integer, cstring, internal, integer)
|
postgres |
|
|
sjis_to_mic(integer, integer, cstring, internal, integer)
|
postgres |
|
|
sjis_to_utf8(integer, integer, cstring, internal, integer)
|
postgres |
|
|
slope(point, point)
|
postgres |
slope between points |
|
smgreq(smgr, smgr)
|
postgres |
storage manager |
|
smgrin(cstring)
|
postgres |
I/O |
|
smgrne(smgr, smgr)
|
postgres |
storage manager |
|
smgrout(smgr)
|
postgres |
I/O |
|
split_part(text, text, integer)
|
postgres |
split string by field_sep and return field_num |
|
sqrt(double precision)
|
postgres |
square root |
|
sqrt(numeric)
|
postgres |
square root |
|
statement_timestamp()
|
postgres |
current statement time |
|
string_to_array(text, text)
|
postgres |
split delimited text into text[] |
|
strpos(text, text)
|
postgres |
find position of substring |
|
substr(bytea, integer, integer)
|
postgres |
return portion of string |
|
substr(text, integer)
|
postgres |
return portion of string |
|
substr(text, integer, integer)
|
postgres |
return portion of string |
|
substr(bytea, integer)
|
postgres |
return portion of string |
|
substring(bytea, integer, integer)
|
postgres |
return portion of string |
|
substring(bit, integer, integer)
|
postgres |
return portion of bitstring |
|
substring(bytea, integer)
|
postgres |
return portion of string |
|
substring(text, integer)
|
postgres |
return portion of string |
|
substring(text, integer, integer)
|
postgres |
return portion of string |
|
substring(text, text)
|
postgres |
extracts text matching regular expression |
|
substring(text, text, text)
|
postgres |
extracts text matching SQL99 regular expression |
|
substring(bit, integer)
|
postgres |
return portion of bitstring |
|
tan(double precision)
|
postgres |
tangent |
|
text(time with time zone)
|
postgres |
convert timetz to text |
|
text(numeric)
|
postgres |
(internal) |
|
text(inet)
|
postgres |
show all parts of inet/cidr value |
|
text(macaddr)
|
postgres |
MAC address to text |
|
text(timestamp without time zone)
|
postgres |
convert timestamp to text |
|
text(character)
|
postgres |
convert char(n) to text |
|
text(name)
|
postgres |
convert name to text |
|
text(oid)
|
postgres |
convert oid to text |
|
text(smallint)
|
postgres |
convert int2 to text |
|
text(integer)
|
postgres |
convert int4 to text |
|
text(bigint)
|
postgres |
convert int8 to text |
|
text(interval)
|
postgres |
convert interval to text |
|
text(timestamp with time zone)
|
postgres |
convert timestamp with time zone to text |
|
text(time without time zone)
|
postgres |
convert time to text |
|
text(date)
|
postgres |
convert date to text |
|
text("char")
|
postgres |
convert char to text |
|
text(real)
|
postgres |
convert float4 to text |
|
text(double precision)
|
postgres |
convert float8 to text |
|
text_ge(text, text)
|
postgres |
greater-than-or-equal |
|
text_gt(text, text)
|
postgres |
greater-than |
|
text_larger(text, text)
|
postgres |
larger of two |
|
text_le(text, text)
|
postgres |
less-than-or-equal |
|
text_lt(text, text)
|
postgres |
less-than |
|
text_pattern_eq(text, text)
|
postgres |
|
|
text_pattern_ge(text, text)
|
postgres |
|
|
text_pattern_gt(text, text)
|
postgres |
|
|
text_pattern_le(text, text)
|
postgres |
|
|
text_pattern_lt(text, text)
|
postgres |
|
|
text_pattern_ne(text, text)
|
postgres |
|
|
text_smaller(text, text)
|
postgres |
smaller of two |
|
textcat(text, text)
|
postgres |
concatenate |
|
texteq(text, text)
|
postgres |
equal |
|
texticlike(text, text)
|
postgres |
matches LIKE expression, case-insensitive |
|
texticnlike(text, text)
|
postgres |
does not match LIKE expression, case-insensitive |
|
texticregexeq(text, text)
|
postgres |
matches regex., case-insensitive |
|
texticregexne(text, text)
|
postgres |
does not match regex., case-insensitive |
|
textin(cstring)
|
postgres |
I/O |
|
textlen(text)
|
postgres |
length |
|
textlike(text, text)
|
postgres |
matches LIKE expression |
|
textne(text, text)
|
postgres |
not equal |
|
textnlike(text, text)
|
postgres |
does not match LIKE expression |
|
textout(text)
|
postgres |
I/O |
|
textrecv(internal)
|
postgres |
I/O |
|
textregexeq(text, text)
|
postgres |
matches regex., case-sensitive |
|
textregexne(text, text)
|
postgres |
does not match regex., case-sensitive |
|
textsend(text)
|
postgres |
I/O |
|
tideq(tid, tid)
|
postgres |
equal |
|
tidge(tid, tid)
|
postgres |
greater-than-or-equal |
|
tidgt(tid, tid)
|
postgres |
greater-than |
|
tidin(cstring)
|
postgres |
I/O |
|
tidlarger(tid, tid)
|
postgres |
larger of two |
|
tidle(tid, tid)
|
postgres |
less-than-or-equal |
|
tidlt(tid, tid)
|
postgres |
less-than |
|
tidne(tid, tid)
|
postgres |
not equal |
|
tidout(tid)
|
postgres |
I/O |
|
tidrecv(internal)
|
postgres |
I/O |
|
tidsend(tid)
|
postgres |
I/O |
|
tidsmaller(tid, tid)
|
postgres |
smaller of two |
|