diff options
Diffstat (limited to 'src/man/built-in.3')
| -rw-r--r-- | src/man/built-in.3 | 1105 |
1 files changed, 0 insertions, 1105 deletions
diff --git a/src/man/built-in.3 b/src/man/built-in.3 deleted file mode 100644 index 5e801b66261..00000000000 --- a/src/man/built-in.3 +++ /dev/null @@ -1,1105 +0,0 @@ -.\" This is -*-nroff-*- -.\" XXX standard disclaimer belongs here.... -.\" $Header: /cvsroot/pgsql/src/man/Attic/built-in.3,v 1.9 1997/08/26 17:00:11 momjian Exp $ -.TH PGBUILTIN INTRO 04/01/97 PostgreSQL PostgreSQL -.SH "DESCRIPTION" -This section describes the data types, functions and operators -available to users in Postgres as it is distributed. -.SH "PGBUILTIN TYPES" -This section describes -.BR pgbuiltin -data types. -These Built-in types 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) limited-range 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 - datetime general-use date and time - 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 - money decimal type with fixed precision - 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 open or closed line segments - point 2-dimensional geometric point - polygon 2-dimensional polygon (same as a closed path) - circle 2-dimensional circle (center and radius) - real alias for float4 - regproc registered procedure - reltime (relative) date and time span (duration) - smgr storage manager - smallint alias for int2 - text variable length array of characters - tid tuple identifier type - time ANSI SQL time type - timespan general-use time span (duration) - timestamp limited-range ISO-format date and time - tinterval time interval (start and stop abstime) - varchar variable-length characters - xid transaction identifier type - -.fi -.in -.PP -Many of the built-in types have obvious external formats. However, several -types are either unique to Postgres, such as open and closed paths, or have -several possibilities for formats, such as date and time types. - -.SH "Syntax of date and time types" -Some date and time types share code for data input. For those types (currently -.IR datetime -and -.IR abstime -, and -.IR timespan -and -.IR reltime ) -the input can have any of a wide variety of styles. For numeric date representations, -European and US conventions can differ, and the proper interpretation is obtained -by using the -.IR set (l) -command before entering data. -Output formats can be set to one of three styles: -ISO-8601, SQL (traditional Oracle/Ingres), and traditional -Postgres (see section on -.IR "absolute time" ) -with the SQL style having European and US variants (see -.IR set (l)). - -.SH "DATETIME" -General-use date and time is input using a wide range of -styles, including ISO-compatible, SQL-compatible, traditional -Postgres (see section on -.IR "absolute time") -and other permutations of date and time. Output styles can be ISO-compatible, -SQL-compatible, or traditional Postgres, with the default set to be compatible -with Postgres v6.0. -.PP -datetime is specified using the following syntax: -.PP -.nf -Year-Month-Day [ Hour : Minute : Second ] [AD,BC] [ Timezone ] -.nf - YearMonthDay [ Hour : Minute : Second ] [AD,BC] [ Timezone ] -.nf - Month Day [ Hour : Minute : Second ] Year [AD,BC] [ Timezone ] -.sp -where - Year is 4013 BC, ..., very large - Month is Jan, Feb, ..., Dec or 1, 2, ..., 12 - Day is 1, 2, ..., 31 - Hour is 00, 02, ..., 23 - Minute is 00, 01, ..., 59 - Second is 00, 01, ..., 59 (60 for leap second) - Timezone is 3 characters or ISO offset to GMT -.fi -.PP -Valid dates are from Nov 13 00:00:00 4013 BC GMT to far into the future. -Timezones are either three characters (e.g. "GMT" or "PST") or ISO-compatible -offsets to GMT (e.g. "-08" or "-08:00" when in Pacific Standard Time). -Dates are stored internally in Greenwich Mean Time. Input and output routines -translate time to the local time zone of the server. -.PP -The special values `current', -`infinity' and `-infinity' are provided. -`infinity' specifies a time later than any valid time, and -`-infinity' specifies a time earlier than any valid time. -`current' indicates that the current time should be -substituted whenever this value appears in a computation. -.PP -The strings -`now', -`today', -`yesterday', -`tomorrow', -and `epoch' can be used to specify -time values. `now' means the current time, and differs from -`current' in that the current time is immediately substituted -for it. `epoch' means Jan 1 00:00:00 1970 GMT. - -.SH "TIMESPAN" -General-use time span is input using a wide range of -syntaxes, including ISO-compatible, SQL-compatible, traditional -Postgres (see section on -.IR "relative time" -) and other permutations of time span. Output formats can be ISO-compatible, -SQL-compatible, or traditional Postgres, with the default set to be Postgres-compatible. -Months and years are a "qualitative" time interval, and are stored separately -from the other "quantitative" time intervals such as day or hour. For date arithmetic, -the qualitative time units are instantiated in the context of the relevant date or time. -.PP -Time span is specified with the following syntax: -.PP -.nf - Quantity Unit [Quantity Unit...] [Direction] -.nf -@ Quantity Unit [Direction] -.sp -where - Quantity is ..., `-1', `0', `1', `2', ... - Unit is `second', `minute', `hour', `day', `week', `month', `year', - or abbreviations or plurals of these units. - Direction is `ago'. -.fi -.SH "ABSOLUTE TIME" -Absolute time (abstime) is a limited-range (+/- 68 years) and limited-precision (1 sec) -date data type. -.IR "datetime" -may be preferred, since it -covers a larger range with greater precision. -.PP -Absolute time is specified using the following syntax: -.PP -.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 -.PP -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 -All special values allowed for -.IR "datetime" -are also allowed for -.IR "absolute time". - -.SH "RELATIVE TIME" -Relative time (reltime) is a limited-range (+/- 68 years) and limited-precision (1 sec) -time span data type. -.IR "timespan" -may be preferred, since it -covers a larger range with greater precision, allows multiple units -for an entry, and correctly handles qualitative time -units such as year and month. For reltime, only one quantity and unit is allowed -per entry, which can be inconvenient for complicated time spans. -.PP -Relative time is specified with the following syntax: -.PP -.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: -.PP -.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 "Syntax of geometric types" -.SH "POINT" -Points are specified using the following syntax: -.PP -.nf -( x , y ) -.nf - x , y -.sp -where - x is the x-axis coordinate as a floating point number - y is the y-axis coordinate as a floating point number -.fi -.PP -.SH "LSEG" -Line segments are represented by pairs of points. -.PP -lseg is specified using the following syntax: -.PP -.nf -( ( x1 , y1 ) , ( x2 , y2 ) ) -.nf - ( x1 , y1 ) , ( x2 , y2 ) -.nf - x1 , y1 , x2 , y2 -.sp -where - (x1,y1) and (x2,y2) are the endpoints of the segment -.fi -.PP -.SH "BOX" -Boxes are represented by pairs of points which are opposite -corners of the box. -.PP -box is specified using the following syntax: -.PP -.nf -( ( x1 , y1 ) , ( x2 , y2 ) ) -.nf - ( x1 , y1 ) , ( x2 , y2 ) -.nf - x1 , y1 , x2 , y2 -.sp -where - (x1,y1) and (x2,y2) are opposite corners -.fi -.PP -Boxes are output using the first syntax. -The corners are reordered on input to store -the lower left corner first and the upper right corner last. -Other corners of the box can be entered, but the lower -left and upper right corners are determined from the input and stored. -.SH "PATH" -Paths are represented by sets of points. Paths can be "open", where -the first and last points in the set are not connected, and "closed", -where the first and last point are connected. Functions -.IR popen(p) -and -.IR pclose(p) -are supplied to force a path to be open or closed, and functions -.IR isopen(p) -and -.IR isclosed(p) -are supplied to select either type in a query. -.PP -path is specified using the following syntax: -.PP -.nf -( ( x1 , y1 ) , ... , ( xn , yn ) ) -.nf -[ ( x1 , y1 ) , ... , ( xn , yn ) ] -.nf - ( x1 , y1 ) , ... , ( xn , yn ) -.nf - x1 , y1 , ... , xn , yn -.nf -( closed, n, x1 , y1 , ... , xn , yn ) -.sp -where - (x1,y1),...,(xn,yn) are points 1 through n - a leading "[" indicates an open path - a leading "(" indicates a closed path - a single leading "(" indicates a v6.0-compatible format - closed is an integer flag which is zero for an open path - n is the number of points in the path -.fi -.PP -Paths are output using the first syntax. -The last format is supplied to be backward compatible with v6.0 and earlier -path formats and will not be supported in future versions of Postgres. -.SH "POLYGON" -Polygons are represented by sets of points. Polygons should probably be -considered -equivalent to closed paths, but are stored differently and have their own -set of support routines. -.PP -polygon is specified using the following syntax: -.PP -.nf -( ( x1 , y1 ) , ... , ( xn , yn ) ) -.nf - ( x1 , y1 ) , ... , ( xn , yn ) -.nf - x1 , y1 , ... , xn , yn -.nf -( x1 , ... , xn , y1 , ... , yn ) -.sp -where - (x1,y1),...,(xn,yn) are points 1 through n - a single leading "(" indicates a v6.0-compatible format -.fi -.PP -Polygons are output using the first syntax. -The last format is supplied to be backward compatible with v6.0 and earlier -path formats and will not be supported in future versions of Postgres. -.SH "CIRCLE" -Circles are represented by a center point and a radius. -.PP -circle is specified using the following syntax: -.PP -.nf -< ( x , y ) , r > -.nf -( ( x , y ) , r ) -.nf - ( x , y ) , r -.nf - x , y , r -.sp -where - (x,y) is the center of the circle - r is the radius of the circle -.fi -.PP -Circles are output using the first syntax. - -.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" - -.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 - <===> distance between - -float8 - ^ exponentiation - % truncate to integer - |/ square root - ||/ cube root - : exponential function - ; natural logarithm (in psql, protect with parentheses) - -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 - -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 - -circle - && circles 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 -.fi - -.SH "FUNCTIONS" -Many data types have functions available for conversion to other related types. -In addition, there are some type-specific functions. -.PP -For the -date_part() and date_trunc() -functions, arguments can be -`year', `month', `day', `hour', `minute', and `second', -as well as the more specialized quantities -`decade', `century', `millenium', `millisecond', and `microsecond'. -date_part() also allows -`dow' -to return day of week and `epoch' to return seconds since 1970. - -.nf -Functions: - -abstime - datetime datetime(abstime) convert to datetime - bool isfinite(abstime) TRUE if this is a finite time - -date - datetime datetime(date) convert to datetime - datetime datetime(date,time) convert to datetime - -datetime - abstime abstime(datetime) convert to abstime - float8 date_part(text,datetime) specified portion of date field - datetime date_trunc(text,datetime) truncate date at specified units - bool isfinite(datetime) TRUE if this is a finite time - -reltime - timespan timespan(reltime) convert to timespan - -time - datetime datetime(date,time) convert to datetime - -timespan - float8 date_part(text,timespan) specified portion of time field - bool isfinite(timespan) TRUE if this is a finite time - reltime reltime(timespan) convert to reltime - -box - box box(point,point) convert points to box - float8 area(box) area of box - -path - bool isopen(path) TRUE if this is an open path - bool isclosed(path) TRUE if this is a closed path - -circle - circle circle(point,float8) convert to circle - polygon polygon(npts,circle) convert to polygon with npts points - float8 center(circle) radius of circle - float8 radius(circle) radius of circle - float8 diameter(circle) diameter of circle - float8 area(circle) area of circle -.fi - -.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 -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 |< |boollt -bool |bool |bool |<> |boolne -bool |bool |bool |= |booleq -bool |bool |bool |> |boolgt -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 |circle |circle |!^ |circle_above -bool |circle |circle |!\| |circle_below -bool |circle |circle |&& |circle_overlap -bool |circle |circle |&< |circle_overleft -bool |circle |circle |&> |circle_overright -bool |circle |circle |< |circle_eq -bool |circle |circle |<< |circle_left -bool |circle |circle |<= |circle_eq -bool |circle |circle |<> |circle_ne -bool |circle |circle |= |circle_eq -bool |circle |circle |> |circle_eq -bool |circle |circle |>= |circle_eq -bool |circle |circle |>> |circle_right -bool |circle |circle |@ |circle_contained -bool |circle |circle |~ |circle_contain -bool |circle |circle |~= |circle_same -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 |datetime |datetime |< |datetime_lt -bool |datetime |datetime |<= |datetime_le -bool |datetime |datetime |<> |datetime_ne -bool |datetime |datetime |= |datetime_eq -bool |datetime |datetime |> |datetime_gt -bool |datetime |datetime |>= |datetime_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 |money |money |< |cash_lt -bool |money |money |<= |cash_le -bool |money |money |<> |cash_ne -bool |money |money |= |cash_eq -bool |money |money |> |cash_gt -bool |money |money |>= |cash_ge -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 |timespan |timespan |< |timespan_lt -bool |timespan |timespan |<= |timespan_le -bool |timespan |timespan |<> |timespan_ne -bool |timespan |timespan |= |timespan_eq -bool |timespan |timespan |> |timespan_gt -bool |timespan |timespan |>= |timespan_ge -bool |timestamp |timestamp |< |timestamplt -bool |timestamp |timestamp |<= |timestample -bool |timestamp |timestamp |<> |timestampne -bool |timestamp |timestamp |= |timestampeq -bool |timestamp |timestamp |> |timestampgt -bool |timestamp |timestamp |>= |timestampge -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 -date |date |int4 |+ |date_pli -date |date |int4 |- |date_mii -datetime |datetime |timespan |+ |datetime_add_span -datetime |datetime |timespan |- |datetime_sub_span -float4 |float4 |float4 |* |float4mul -float4 |float4 |float4 |+ |float4pl -float4 |float4 |float4 |- |float4mi -float4 |float4 |float4 |/ |float4div -float8 |box |box |<===> |box_distance -float8 |circle |circle |<===> |circle_distance -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 -float8 |lseg |box |<===> |dist_sb -float8 |lseg |lseg |<===> |lseg_distance -float8 |path |path |<===> |path_distance -float8 |point |box |<===> |dist_pl -float8 |point |box |<===> |dist_ps -float8 |point |box |<===> |dist_pb -float8 |point |lseg |<===> |dist_ps -float8 |point |path |<===> |dist_ppth -float8 |point |point |<===> |point_distance -int2 |int2 |int2 |% |int2mod -int2 |int2 |int2 |* |int2mul -int2 |int2 |int2 |+ |int2pl -int2 |int2 |int2 |- |int2mi -int2 |int2 |int2 |/ |int2div -int4 |date |date |- |date_mi -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 -money |money |float8 |* |cash_mul -money |money |float8 |/ |cash_div -money |money |money |+ |cash_pl -money |money |money |- |cash_mi -timespan |datetime |datetime |- |datetime_sub -timespan |timespan |timespan |+ |timespan_add -timespan |timespan |timespan |- |timespan_sub -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 -# |polygon |int4 -- |timespan |timespan -| |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 -avg |money -max |abstime -max |date -max |datetime -max |float4 -max |float8 -max |int2 -max |int4 -max |money -max |timespan -min |abstime -min |date -min |datetime -min |float4 -min |float8 -min |int2 -min |int4 -min |money -min |timespan -sum |float4 -sum |float8 -sum |int2 -sum |int4 -sum |money - -.fi -\fBcount\fR is also available, where \fBcount(*)\fR returns a count of all -rows while \fBcount(column_name)\fR returns a count of all non-null fields -in the specified column. - -.in -.SH "SEE ALSO" -.IR set (l), -.IR show (l), -.IR reset (l). -For examples on specifying literals of built-in types, see -.IR SQL (l). -.SH BUGS -.PP -Although most of the input and output functions corresponding to the -base types (e.g., integers and floating point numbers) do some -error-checking, some are not particularly rigorous about it. More -importantly, few of the operators and functions (e.g., -addition and multiplication) perform any error-checking at all. -Consequently, many of the numeric operators can (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. |