11.\" This is -*-nroff-*-
22.\" XXX standard disclaimer belongs here....
3- .\" $Header: /cvsroot/pgsql/src/man/Attic/pgbuiltin.3,v 1.3 1997/09/1602:49:23 momjian Exp $
3+ .\" $Header: /cvsroot/pgsql/src/man/Attic/pgbuiltin.3,v 1.4 1997/09/1603:01:43 momjian Exp $
44.TH PGBUILTIN INTRO 04/01/97 PostgreSQL PostgreSQL
55.SH "DESCRIPTION"
66This section describes the data types, functions and operators
@@ -1075,6 +1075,7 @@ registered in the system catalogs.
10751075This list was generated from the Postgres system catalogs with the query:
10761076
10771077.nf
1078+ .eo
10781079SELECT o.oprname AS left_unary,
10791080 t.typname AS operand,
10801081 r.typname AS return_type
@@ -1112,6 +1113,7 @@ left_unary|operand |return_type
11121113\| |tinterval|abstime
11131114(24 rows)
11141115
1116+ .ec
11151117.fi
11161118.in
11171119.SH "RIGHT UNARY OPERATORS"
@@ -1121,6 +1123,7 @@ registered in the system catalogs.
11211123This list was generated from the Postgres system catalogs with the query:
11221124
11231125.nf
1126+ .eo
11241127SELECT o.oprname AS right_unary,
11251128 t.typname AS operand,
11261129 r.typname AS return_type
@@ -1136,6 +1139,7 @@ right_unary|operand|return_type
11361139! |int4 |int4
11371140(2 rows)
11381141
1142+ .ec
11391143.fi
11401144.in
11411145.SH "AGGREGATE FUNCTIONS"
@@ -1145,6 +1149,7 @@ registered in the system catalogs.
11451149This list was generated from the Postgres system catalogs with the query:
11461150
11471151.nf
1152+ .eo
11481153SELECT a.aggname, t.typname
11491154FROM pg_aggregate a, pg_type t
11501155WHERE a.aggbasetype = t.oid
@@ -1184,6 +1189,7 @@ sum |money
11841189sum |timespan
11851190(30 rows)
11861191
1192+ .ec
11871193.fi
11881194\fB count \fR is also available, where\fB count(*) \fR returns a count of all
11891195rows while\fB count(column_name) \fR returns a count of all non-null fields