aboutsummaryrefslogtreecommitdiff
path: root/doc/man/built-in.3
diff options
context:
space:
mode:
authorMarc G. Fournier <scrappy@hub.org>1996-11-14 10:15:16 +0000
committerMarc G. Fournier <scrappy@hub.org>1996-11-14 10:15:16 +0000
commit389fe48cbb513888205bbe3a5008ed109976dacb (patch)
treee1bc978627338c127aa0d9c0fdbd8bed7fa6821c /doc/man/built-in.3
parent65a10b1be6400025e7fd54befbc4a8489fd50e10 (diff)
downloadpostgresql-389fe48cbb513888205bbe3a5008ed109976dacb.tar.gz
postgresql-389fe48cbb513888205bbe3a5008ed109976dacb.zip
Removed man pages...moved to src/man
Requested by Bryan
Diffstat (limited to 'doc/man/built-in.3')
-rw-r--r--doc/man/built-in.3700
1 files changed, 0 insertions, 700 deletions
diff --git a/doc/man/built-in.3 b/doc/man/built-in.3
deleted file mode 100644
index 48af4cbe316..00000000000
--- a/doc/man/built-in.3
+++ /dev/null
@@ -1,700 +0,0 @@
-.\" This is -*-nroff-*-
-.\" XXX standard disclaimer belongs here....
-.\" $Header: /cvsroot/pgsql/doc/man/Attic/built-in.3,v 1.1.1.1 1996/08/18 22:14:20 scrappy Exp $
-.TH BUILT-INS INTRO 11/05/95 Postgres95 Postgres95
-.SH "DESCRIPTION"
-This section describes the data types, functions and operators
-available to users in Postgres as it is distributed.
-.SH "Built-in and System Types"
-.SH "BUILT-IN TYPES"
-This section describes both
-.BR built-in
-data types.
-These Built-in types are
-are installed in every database.
-.PP
-Users may add new types to Postgres using the
-.IR "define type"
-command described in this manual. User-defined types are not
-described in this section.
-.SH "List of built-in types"
-.PP
-.if n .ta 5 +15 +40
-.if t .ta 0.5i +1.5i +3.0i
-.in 0
-.nf
- \fBPOSTGRES Type\fP \fBMeaning\fP
- abstime absolute date and time
- aclitem access control list item
- bool boolean
- box 2-dimensional rectangle
- bpchar blank-padded characters
- bytea variable length array of bytes
- char character
- char2 array of 2 characters
- char4 array of 4 characters
- char8 array of 8 characters
- char16 array of 16 characters
- cid command identifier type
- date ANSI SQL date type
- filename large object filename
- int alias for int4
- integer alias for int4
- int2 two-byte signed integer
- int28 array of 8 int2
- int4 four-byte signed integer
- float alias for float4
- float4 single-precision floating-point number
- float8 double-precision floating-point number
- lseg 2-dimensional line segment
- name a multi-character type for storing system identifiers
- oid object identifier type
- oid8 array of 8 oid
- oidchar16 oid and char16 composed
- oidint2 oid and int2 composed
- oidint4 oid and int4 composed
- path variable-length array of lseg
- point 2-dimensional geometric point
- polygon 2-dimensional polygon
- real alias for float4
- regproc registered procedure
- reltime relative date and time
- smgr storage manager
- smallint alias for int2
- text variable length array of characters
- tid tuple identifier type
- time ANSI SQL time type
- tinterval time interval
- varchar variable-length characters
- xid transaction identifier type
-
-.fi
-.in
-.PP
-As a rule, the built-in types are all either (1) internal types, in
-which case the user should not worry about their external format, or
-(2) have obvious formats. The exceptions to this rule are the three
-time types.
-.SH "Syntax of date and time types"
-.SH "ABSOLUTE TIME"
-Absolute time is specified using the following syntax:
-.nf
-Month Day [ Hour : Minute : Second ] Year [ Timezone ]
-.sp
-where
- Month is Jan, Feb, ..., Dec
- Day is 1, 2, ..., 31
- Hour is 01, 02, ..., 24
- Minute is 00, 01, ..., 59
- Second is 00, 01, ..., 59
- Year is 1901, 1902, ..., 2038
-.fi
-Valid dates are from Dec 13 20:45:53 1901 GMT to Jan 19 03:14:04
-2038 GMT. As of Version 3.0, times are no longer read and written
-using Greenwich Mean Time; the input and output routines default to
-the local time zone.
-.PP
-The special absolute time values \*(lqcurrent\*(rq,
-\*(lqinfinity\*(rq and \*(lq-infinity\*(rq are also provided.
-\*(lqinfinity\*(rq specifies a time later than any valid time, and
-\*(lq-infinity\*(rq specifies a time earlier than any valid time.
-\*(lqcurrent\*(rq indicates that the current time should be
-substituted whenever this value appears in a computation.
-.PP
-The strings \*(lqnow\*(rq and \*(lqepoch\*(rq can be used to specify
-time values. \*(lqnow\*(rq means the current time, and differs from
-\*(lqcurrent\*(rq in that the current time is immediately substituted
-for it. \*(lqepoch\*(rq means Jan 1 00:00:00 1970 GMT.
-.SH "RELATIVE TIME"
-Relative time is specified with the following syntax:
-.nf
-@ Quantity Unit [Direction]
-.sp
-where
- Quantity is `1', `2', ...
- Unit is ``second'', ``minute'', ``hour'', ``day'', ``week'',
- ``month'' (30-days), or ``year'' (365-days),
- or PLURAL of these units.
- Direction is ``ago''
-.fi
-.PP
-.RB ( Note :
-Valid relative times are less than or equal to 68 years.)
-In addition, the special relative time \*(lqUndefined RelTime\*(rq is
-provided.
-.SH "TIME RANGES"
-Time ranges are specified as:
-.nf
-[ 'abstime' 'abstime']
-.fi
-where
-.IR abstime
-is a time in the absolute time format. Special abstime values such as
-\*(lqcurrent\*(rq, \*(lqinfinity\*(rq and \*(lq-infinity\*(rq can be used.
-.SH "Built-in operators and functions"
-.SH OPERATORS
-Postgres provides a large number of built-in operators on system types.
-These operators are declared in the system catalog
-\*(lqpg_operator\*(rq. Every entry in \*(lqpg_operator\*(rq includes
-the object ID of the procedure that implements the operator.
-.PP
-Users may invoke operators using the operator name, as in
-.nf
-select * from emp where salary < 40000;
-.fi
-Alternatively, users may call the functions that implement the
-operators directly. In this case, the query above would be expressed
-as
-.nf
-select * from emp where int4lt(salary, 40000);
-.fi
-The rest of this section provides a list of the built-in operators and
-the functions that implement them. Binary operators are listed first,
-followed by unary operators.
-.SH "BINARY OPERATORS"
-This list was generated from the Postgres system catalogs with the
-query:
-
-.nf
-SELECT
- t0.typname AS result,
- t1.typname AS left_type,
- t2.typname AS right_type,
- o.oprname AS operatr,
- p.proname AS func_name
-FROM pg_proc p, pg_type t0,
- pg_type t1, pg_type t2,
- pg_operator o
-WHERE p.prorettype = t0.oid AND
- RegprocToOid(o.oprcode) = p.oid AND
- p.pronargs = 2 AND
- o.oprleft = t1.oid AND
- o.oprright = t2.oid
-ORDER BY result, left_type, right_type, operatr;
-.fi
-
-These operations are cast in terms of SQL types and so are
-.BR not
-directly usable as C function prototypes.
-
-.nf
-Operators:
-
-general
- <\(eq less or equal
- <> inequality
- < less than
- <\(eq greater or equal
- >\(eq greater or equal
- > greater than
- \(eq equality
- ~ A matches regular expression B, case-sensitive
- !~ A does not match regular expression B, case-sensitive
- ~* A matches regular expression B, case-insensitive.
- !~* A does not match regular expression B, case-insensitive
- ~~ A matches LIKE expression B, case-sensitive
- !~~ A does not match LIKE expression B, case-sensitive
-
- + addition
- \(mi subtraction
- * multiplication
- / division
- % modulus
- @ absolute value
-
-float8
- ^ exponentiation
- % truncate to integer
- |/ square root
- ||/ cube root
- : exponential function
- ; natural logarithm
-
-point
- !< A is left of B
- !> A is right of B
- !^ A is above B
- !| A is below B
- \(eq|\(eq equality
- ===> point inside box
- ===` point on path
- <===> distance between points
-
-box
- && boxes overlap
- &< box A overlaps box B, but does not extend to right of box B
- &> box A overlaps box B, but does not extend to left of box B
- << A is left of B
- \(eq area equal
- < area less than
- <\(eq area less or equal
- >\(eq area greater or equal
- > area greater than
- >> A is right of B
- @ A is contained in B
- ~\(eq box equality
- ~= A same as B
- ~ A contains B
- @@ center of box
-
-polygon
- && polygons overlap
- &< A overlaps B but does not extend to right of B
- &> A overlaps B but does not extend to left of B
- << A is left of B
- >> A is right of B
- @ A is contained by B
- ~\(eq equality
- ~= A same as B
- ~ A contains B
-
-tinterval
- #<\(eq interval length less or equal reltime
- #<> interval length not equal to reltime.
- #< interval length less than reltime
- #\(eq interval length equal to reltime
- #>\(eq interval length greater or equal reltime
- #> interval length greater than reltime
- && intervals overlap
- << A contains B
- \(eq equality
- <> interval bounded by two abstimes
- <?> abstime in tinterval
- | start of interval
- <#> convert to interval
-
-result |left_type |right_type|operatr|func_name
----------+----------+----------+-------+---------------
-_aclitem |_aclitem |aclitem |+ |aclinsert
-_aclitem |_aclitem |aclitem |- |aclremove
-abstime |abstime |reltime |+ |timepl
-abstime |abstime |reltime |- |timemi
-bool |_abstime |_abstime |= |array_eq
-bool |_aclitem |_aclitem |= |array_eq
-bool |_aclitem |aclitem |~ |aclcontains
-bool |_bool |_bool |= |array_eq
-bool |_box |_box |= |array_eq
-bool |_bytea |_bytea |= |array_eq
-bool |_char |_char |= |array_eq
-bool |_char16 |_char16 |= |array_eq
-bool |_cid |_cid |= |array_eq
-bool |_filename |_filename |= |array_eq
-bool |_float4 |_float4 |= |array_eq
-bool |_float8 |_float8 |= |array_eq
-bool |_int2 |_int2 |= |array_eq
-bool |_int28 |_int28 |= |array_eq
-bool |_int4 |_int4 |= |array_eq
-bool |_lseg |_lseg |= |array_eq
-bool |_name |_name |= |array_eq
-bool |_oid |_oid |= |array_eq
-bool |_oid8 |_oid8 |= |array_eq
-bool |_path |_path |= |array_eq
-bool |_point |_point |= |array_eq
-bool |_polygon |_polygon |= |array_eq
-bool |_ref |_ref |= |array_eq
-bool |_regproc |_regproc |= |array_eq
-bool |_reltime |_reltime |= |array_eq
-bool |_stub |_stub |= |array_eq
-bool |_text |_text |= |array_eq
-bool |_tid |_tid |= |array_eq
-bool |_tinterval|_tinterval|= |array_eq
-bool |_xid |_xid |= |array_eq
-bool |abstime |abstime |< |abstimelt
-bool |abstime |abstime |<= |abstimele
-bool |abstime |abstime |<> |abstimene
-bool |abstime |abstime |= |abstimeeq
-bool |abstime |abstime |> |abstimegt
-bool |abstime |abstime |>= |abstimege
-bool |abstime |tinterval |<?> |ininterval
-bool |bool |bool |<> |boolne
-bool |bool |bool |= |booleq
-bool |box |box |&& |box_overlap
-bool |box |box |&< |box_overleft
-bool |box |box |&> |box_overright
-bool |box |box |< |box_lt
-bool |box |box |<< |box_left
-bool |box |box |<= |box_le
-bool |box |box |= |box_eq
-bool |box |box |> |box_gt
-bool |box |box |>= |box_ge
-bool |box |box |>> |box_right
-bool |box |box |@ |box_contained
-bool |box |box |~ |box_contain
-bool |box |box |~= |box_same
-bool |bpchar |bpchar |< |bpcharlt
-bool |bpchar |bpchar |<= |bpcharle
-bool |bpchar |bpchar |<> |bpcharne
-bool |bpchar |bpchar |= |bpchareq
-bool |bpchar |bpchar |> |bpchargt
-bool |bpchar |bpchar |>= |bpcharge
-bool |bpchar |text |!~ |textregexne
-bool |bpchar |text |!~* |texticregexne
-bool |bpchar |text |!~~ |textnlike
-bool |bpchar |text |~ |textregexeq
-bool |bpchar |text |~* |texticregexeq
-bool |bpchar |text |~~ |textlike
-bool |char |char |< |charlt
-bool |char |char |<= |charle
-bool |char |char |<> |charne
-bool |char |char |= |chareq
-bool |char |char |> |chargt
-bool |char |char |>= |charge
-bool |char16 |char16 |< |char16lt
-bool |char16 |char16 |<= |char16le
-bool |char16 |char16 |<> |char16ne
-bool |char16 |char16 |= |char16eq
-bool |char16 |char16 |> |char16gt
-bool |char16 |char16 |>= |char16ge
-bool |char16 |text |!~ |char16regexne
-bool |char16 |text |!~* |char16icregexne
-bool |char16 |text |!~~ |char16nlike
-bool |char16 |text |!~~ |char16nlike
-bool |char16 |text |~ |char16regexeq
-bool |char16 |text |~* |char16icregexeq
-bool |char16 |text |~~ |char16like
-bool |char16 |text |~~ |char16like
-bool |char2 |char2 |< |char2lt
-bool |char2 |char2 |<= |char2le
-bool |char2 |char2 |<> |char2ne
-bool |char2 |char2 |= |char2eq
-bool |char2 |char2 |> |char2gt
-bool |char2 |char2 |>= |char2ge
-bool |char2 |text |!~ |char2regexne
-bool |char2 |text |!~* |char2icregexne
-bool |char2 |text |!~~ |char2nlike
-bool |char2 |text |~ |char2regexeq
-bool |char2 |text |~* |char2icregexeq
-bool |char2 |text |~~ |char2like
-bool |char4 |char4 |< |char4lt
-bool |char4 |char4 |<= |char4le
-bool |char4 |char4 |<> |char4ne
-bool |char4 |char4 |= |char4eq
-bool |char4 |char4 |> |char4gt
-bool |char4 |char4 |>= |char4ge
-bool |char4 |text |!~ |char4regexne
-bool |char4 |text |!~* |char4icregexne
-bool |char4 |text |!~~ |char4nlike
-bool |char4 |text |~ |char4regexeq
-bool |char4 |text |~* |char4icregexeq
-bool |char4 |text |~~ |char4like
-bool |char8 |char8 |< |char8lt
-bool |char8 |char8 |<= |char8le
-bool |char8 |char8 |<> |char8ne
-bool |char8 |char8 |= |char8eq
-bool |char8 |char8 |> |char8gt
-bool |char8 |char8 |>= |char8ge
-bool |char8 |text |!~ |char8regexne
-bool |char8 |text |!~* |char8icregexne
-bool |char8 |text |!~~ |char8nlike
-bool |char8 |text |~ |char8regexeq
-bool |char8 |text |~* |char8icregexeq
-bool |char8 |text |~~ |char8like
-bool |date |date |< |date_lt
-bool |date |date |<= |date_le
-bool |date |date |<> |date_ne
-bool |date |date |= |date_eq
-bool |date |date |> |date_gt
-bool |date |date |>= |date_ge
-bool |float4 |float4 |< |float4lt
-bool |float4 |float4 |<= |float4le
-bool |float4 |float4 |<> |float4ne
-bool |float4 |float4 |= |float4eq
-bool |float4 |float4 |> |float4gt
-bool |float4 |float4 |>= |float4ge
-bool |float4 |float8 |< |float48lt
-bool |float4 |float8 |<= |float48le
-bool |float4 |float8 |<> |float48ne
-bool |float4 |float8 |= |float48eq
-bool |float4 |float8 |> |float48gt
-bool |float4 |float8 |>= |float48ge
-bool |float8 |float4 |< |float84lt
-bool |float8 |float4 |<= |float84le
-bool |float8 |float4 |<> |float84ne
-bool |float8 |float4 |= |float84eq
-bool |float8 |float4 |> |float84gt
-bool |float8 |float4 |>= |float84ge
-bool |float8 |float8 |< |float8lt
-bool |float8 |float8 |<= |float8le
-bool |float8 |float8 |<> |float8ne
-bool |float8 |float8 |= |float8eq
-bool |float8 |float8 |> |float8gt
-bool |float8 |float8 |>= |float8ge
-bool |int2 |int2 |< |int2lt
-bool |int2 |int2 |<= |int2le
-bool |int2 |int2 |<> |int2ne
-bool |int2 |int2 |= |int2eq
-bool |int2 |int2 |> |int2gt
-bool |int2 |int2 |>= |int2ge
-bool |int4 |int4 |< |int4lt
-bool |int4 |int4 |<= |int4le
-bool |int4 |int4 |<> |int4ne
-bool |int4 |int4 |= |int4eq
-bool |int4 |int4 |> |int4gt
-bool |int4 |int4 |>= |int4ge
-bool |int4 |name |!!= |int4notin
-bool |int4 |oid |= |int4eqoid
-bool |name |name |< |namelt
-bool |name |name |<= |namele
-bool |name |name |<> |namene
-bool |name |name |= |nameeq
-bool |name |name |> |namegt
-bool |name |name |>= |namege
-bool |name |text |!~ |nameregexne
-bool |name |text |!~* |nameicregexne
-bool |name |text |!~~ |namenlike
-bool |name |text |~ |nameregexeq
-bool |name |text |~* |nameicregexeq
-bool |name |text |~~ |namelike
-bool |oid |int4 |= |oideqint4
-bool |oid |name |!!= |oidnotin
-bool |oid |oid |< |int4lt
-bool |oid |oid |<= |int4le
-bool |oid |oid |<> |oidne
-bool |oid |oid |= |oideq
-bool |oid |oid |> |int4gt
-bool |oid |oid |>= |int4ge
-bool |oidint2 |oidint2 |< |oidint2lt
-bool |oidint2 |oidint2 |<= |oidint2le
-bool |oidint2 |oidint2 |<> |oidint2ne
-bool |oidint2 |oidint2 |= |oidint2eq
-bool |oidint2 |oidint2 |> |oidint2gt
-bool |oidint2 |oidint2 |>= |oidint2ge
-bool |oidint4 |oidint4 |< |oidint4lt
-bool |oidint4 |oidint4 |<= |oidint4le
-bool |oidint4 |oidint4 |<> |oidint4ne
-bool |oidint4 |oidint4 |= |oidint4eq
-bool |oidint4 |oidint4 |> |oidint4gt
-bool |oidint4 |oidint4 |>= |oidint4ge
-bool |oidname |oidname |< |oidnamelt
-bool |oidname |oidname |<= |oidnamele
-bool |oidname |oidname |<> |oidnamene
-bool |oidname |oidname |= |oidnameeq
-bool |oidname |oidname |> |oidnamegt
-bool |oidname |oidname |>= |oidnamege
-bool |point |box |===> |on_pb
-bool |point |path |===` |on_ppath
-bool |point |point |!< |point_left
-bool |point |point |!> |point_right
-bool |point |point |!^ |point_above
-bool |point |point |!\| |point_below
-bool |point |point |=\|= |point_eq
-bool |polygon |polygon |&& |poly_overlap
-bool |polygon |polygon |&< |poly_overleft
-bool |polygon |polygon |&> |poly_overright
-bool |polygon |polygon |<< |poly_left
-bool |polygon |polygon |>> |poly_right
-bool |polygon |polygon |@ |poly_contained
-bool |polygon |polygon |~ |poly_contain
-bool |polygon |polygon |~= |poly_same
-bool |reltime |reltime |< |reltimelt
-bool |reltime |reltime |<= |reltimele
-bool |reltime |reltime |<> |reltimene
-bool |reltime |reltime |= |reltimeeq
-bool |reltime |reltime |> |reltimegt
-bool |reltime |reltime |>= |reltimege
-bool |text |text |!~ |textregexne
-bool |text |text |!~* |texticregexne
-bool |text |text |!~~ |textnlike
-bool |text |text |< |text_lt
-bool |text |text |<= |text_le
-bool |text |text |<> |textne
-bool |text |text |= |texteq
-bool |text |text |> |text_gt
-bool |text |text |>= |text_ge
-bool |text |text |~ |textregexeq
-bool |text |text |~* |texticregexeq
-bool |text |text |~~ |textlike
-bool |time |time |< |time_lt
-bool |time |time |<= |time_le
-bool |time |time |<> |time_ne
-bool |time |time |= |time_eq
-bool |time |time |> |time_gt
-bool |time |time |>= |time_ge
-bool |tinterval |reltime |#< |intervallenlt
-bool |tinterval |reltime |#<= |intervallenle
-bool |tinterval |reltime |#<> |intervallenne
-bool |tinterval |reltime |#= |intervalleneq
-bool |tinterval |reltime |#> |intervallengt
-bool |tinterval |reltime |#>= |intervallenge
-bool |tinterval |tinterval |&& |intervalov
-bool |tinterval |tinterval |<< |intervalct
-bool |tinterval |tinterval |= |intervaleq
-bool |varchar |text |!~ |textregexne
-bool |varchar |text |!~* |texticregexne
-bool |varchar |text |!~~ |textnlike
-bool |varchar |text |~ |textregexeq
-bool |varchar |text |~* |texticregexeq
-bool |varchar |text |~~ |textlike
-bool |varchar |varchar |< |varcharlt
-bool |varchar |varchar |<= |varcharle
-bool |varchar |varchar |<> |varcharne
-bool |varchar |varchar |= |varchareq
-bool |varchar |varchar |> |varchargt
-bool |varchar |varchar |>= |varcharge
-char |char |char |* |charmul
-char |char |char |+ |charpl
-char |char |char |- |charmi
-char |char |char |/ |chardiv
-float4 |float4 |float4 |* |float4mul
-float4 |float4 |float4 |+ |float4pl
-float4 |float4 |float4 |- |float4mi
-float4 |float4 |float4 |/ |float4div
-float8 |float4 |float8 |* |float48mul
-float8 |float4 |float8 |+ |float48pl
-float8 |float4 |float8 |- |float48mi
-float8 |float4 |float8 |/ |float48div
-float8 |float8 |float4 |* |float84mul
-float8 |float8 |float4 |+ |float84pl
-float8 |float8 |float4 |- |float84mi
-float8 |float8 |float4 |/ |float84div
-float8 |float8 |float8 |* |float8mul
-float8 |float8 |float8 |+ |float8pl
-float8 |float8 |float8 |- |float8mi
-float8 |float8 |float8 |/ |float8div
-float8 |float8 |float8 |^ |dpow
-int2 |int2 |int2 |% |int2mod
-int2 |int2 |int2 |* |int2mul
-int2 |int2 |int2 |+ |int2pl
-int2 |int2 |int2 |- |int2mi
-int2 |int2 |int2 |/ |int2div
-int4 |int2 |int4 |% |int24mod
-int4 |int2 |int4 |* |int24mul
-int4 |int2 |int4 |+ |int24pl
-int4 |int2 |int4 |- |int24mi
-int4 |int2 |int4 |/ |int24div
-int4 |int2 |int4 |< |int24lt
-int4 |int2 |int4 |<= |int24le
-int4 |int2 |int4 |<> |int24ne
-int4 |int2 |int4 |= |int24eq
-int4 |int2 |int4 |> |int24gt
-int4 |int2 |int4 |>= |int24ge
-int4 |int4 |int2 |% |int42mod
-int4 |int4 |int2 |* |int42mul
-int4 |int4 |int2 |+ |int42pl
-int4 |int4 |int2 |- |int42mi
-int4 |int4 |int2 |/ |int42div
-int4 |int4 |int2 |< |int42lt
-int4 |int4 |int2 |<= |int42le
-int4 |int4 |int2 |<> |int42ne
-int4 |int4 |int2 |= |int42eq
-int4 |int4 |int2 |> |int42gt
-int4 |int4 |int2 |>= |int42ge
-int4 |int4 |int4 |% |int4mod
-int4 |int4 |int4 |* |int4mul
-int4 |int4 |int4 |+ |int4pl
-int4 |int4 |int4 |- |int4mi
-int4 |int4 |int4 |/ |int4div
-int4 |point |point |<===> |pointdist
-tinterval|abstime |abstime |<#> |mktinterval
-
-
-.fi
-.SH "LEFT UNARY OPERATORS"
-The table below gives the left unary operators that are
-registered in the system catalogs.
-
-This list was generated from the Postgres system catalogs with the query:
-
-.nf
-SELECT o.oprname AS left_unary,
- right.typname AS operand,
- result.typname AS return_type
-FROM pg_operator o, pg_type right, pg_type result
-WHERE o.oprkind = 'l' AND -- left unary
- o.oprright = right.oid AND
- o.oprresult = result.oid
-ORDER BY operand;
-
-left_unary|operand |return_type
-----------+---------+-----------
-@@ |box |point
-@ |float4 |float4
-- |float4 |float4
-; |float8 |float8
-: |float8 |float8
-% |float8 |float8
-\|\|/ |float8 |float8
-\|/ |float8 |float8
-@ |float8 |float8
-- |float8 |float8
-- |int2 |int2
-- |int4 |int4
-!! |int4 |int4
-\| |tinterval|abstime
-
-.fi
-.in
-.SH "RIGHT UNARY OPERATORS"
-The table below gives the right unary operators that are
-registered in the system catalogs.
-
-This list was generated from the Postgres system catalogs with the query:
-
-.nf
-SELECT o.oprname AS right_unary,
- left.typname AS operand,
- result.typname AS return_type
-FROM pg_operator o, pg_type left, pg_type result
-WHERE o.oprkind = 'r' AND -- right unary
- o.oprleft = left.oid AND
- o.oprresult = result.oid
-ORDER BY operand;
-
-right_unary|operand|return_type
------------+-------+-----------
-% |float8 |float8
-! |int4 |int4
-
-.fi
-.in
-.SH "AGGREGATE FUNCTIONS"
-The table below gives the aggregate functions that are
-registered in the system catalogs.
-
-This list was generated from the Postgres system catalogs with the query:
-
-.nf
-SELECT a.aggname, t.typname
-FROM pg_aggregate a, pg_type t
-WHERE a.aggbasetype = t.oid
-ORDER BY aggname, typname;
-
-aggname|typname
--------+-------
-avg |float4
-avg |float8
-avg |int2
-avg |int4
-max |float4
-max |float8
-max |int2
-max |int4
-min |float4
-min |float8
-min |int2
-min |int4
-sum |float4
-sum |float8
-sum |int2
-sum |int4
-
-\fBcount\fR is also available.
-
-.fi
-.in
-.SH "SEE ALSO"
-For examples on specifying literals of built-in types, see
-.IR SQL(l).
-.SH BUGS
-.PP
-Although most of the input and output functions correponding to the
-base types (e.g., integers and floating point numbers) do some
-error-checking, none of them are particularly rigorous about it. More
-importantly, almost none of the operators and functions (e.g.,
-addition and multiplication) perform any error-checking at all.
-Consequently, many of the numeric operations will (for example)
-silently underflow or overflow.
-.PP
-Some of the input and output functions are not invertible. That is,
-the result of an output function may lose precision when compared to
-the original input.