Skip to content

Commit c82c955

Browse files
tglsfdctglsfdc
committed
Minor updates/corrections for CREATE/DROP FUNCTION/AGGREGATE/OPERATOR.
1 parent 9ace031 commit c82c955

File tree

4 files changed

+24
-13
lines changed

4 files changed

+24
-13
lines changed

‎doc/src/sgml/ref/drop_aggregate.sgml

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_aggregate.sgml,v 1.8 2000/07/17 03:04:41 tgl Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_aggregate.sgml,v 1.9 2000/10/23 00:46:07 tgl Exp $
33
Postgres documentation
44
-->
55

@@ -47,7 +47,8 @@ DROP AGGREGATE <replaceable class="PARAMETER">name</replaceable> <replaceable cl
4747
<term><replaceable class="parameter">type</replaceable></term>
4848
<listitem>
4949
<para>
50-
The type of an existing aggregate function.
50+
The input datatype of an existing aggregate function,
51+
or <literal>*</literal> if the function accepts any input type.
5152
(Refer to the <citetitle>PostgreSQL User's Guide</citetitle> for
5253
further information about data types.)
5354
<comment>This should become a cross-reference rather than a

‎doc/src/sgml/ref/drop_operator.sgml

Lines changed: 17 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_operator.sgml,v 1.7 2000/10/05 19:48:18 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_operator.sgml,v 1.8 2000/10/23 00:46:07 tgl Exp $
33
Postgres documentation
44
-->
55

@@ -24,7 +24,7 @@ Postgres documentation
2424
<date>1999-07-20</date>
2525
</refsynopsisdivinfo>
2626
<synopsis>
27-
DROP OPERATOR <replaceable class="PARAMETER">id</replaceable> ( <replaceable class="PARAMETER">type</replaceable> | NONE [,...] )
27+
DROP OPERATOR <replaceable class="PARAMETER">id</replaceable> ( <replaceable class="PARAMETER">lefttype</replaceable> | NONE , <replaceable class="PARAMETER">righttype</replaceable> | NONE )
2828
</synopsis>
2929

3030
<refsect2 id="R2-SQL-DROPOPERATOR-1">
@@ -45,10 +45,20 @@ DROP OPERATOR <replaceable class="PARAMETER">id</replaceable> ( <replaceable cla
4545
</listitem>
4646
</varlistentry>
4747
<varlistentry>
48-
<term><replaceable class="parameter">type</replaceable></term>
48+
<term><replaceable class="parameter">lefttype</replaceable></term>
4949
<listitem>
5050
<para>
51-
The type of function parameters.
51+
The type of the operator's left argument; write <literal>NONE</literal> if the
52+
operator has no left argument.
53+
</para>
54+
</listitem>
55+
</varlistentry>
56+
<varlistentry>
57+
<term><replaceable class="parameter">righttype</replaceable></term>
58+
<listitem>
59+
<para>
60+
The type of the operator's right argument; write <literal>NONE</literal> if the
61+
operator has no right argument.
5262
</para>
5363
</listitem>
5464
</varlistentry>
@@ -127,7 +137,7 @@ ERROR: RemoveOperator: right unary operator '<replaceable class="PARAMETER">ope
127137
</para>
128138
<para>
129139
The left or right type of a left or right unary
130-
operator, respectively, may be specified as <literal>NONE</literal>.
140+
operator, respectively, must be specified as <literal>NONE</literal>.
131141
</para>
132142

133143
<refsect2 id="R2-SQL-DROPOPERATOR-3">
@@ -166,13 +176,13 @@ DROP OPERATOR ^ (int4, int4);
166176
</programlisting>
167177
</para>
168178
<para>
169-
Remove left unary negation operator (<literal>b !</literal>) for booleans:
179+
Remove left unary negation operator (<literal>! b</literal>) for booleans:
170180
<programlisting>
171181
DROP OPERATOR ! (none, bool);
172182
</programlisting>
173183
</para>
174184
<para>
175-
Remove right unary factorial operator (<literal>! i</literal>) for
185+
Remove right unary factorial operator (<literal>i !</literal>) for
176186
<literal>int4</literal>:
177187
<programlisting>
178188
DROP OPERATOR ! (int4, none);

‎doc/src/sgml/xaggr.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/xaggr.sgml,v 1.8 2000/07/17 03:04:40 tgl Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/xaggr.sgml,v 1.9 2000/10/23 00:46:06 tgl Exp $
33
-->
44

55
<chapter id="xaggr">
@@ -100,7 +100,7 @@ SELECT complex_sum(a) FROM test_complex;
100100
CREATE AGGREGATE avg (
101101
sfunc = float8_accum,
102102
basetype = float8,
103-
stype = _float8,
103+
stype = float8[],
104104
finalfunc = float8_avg,
105105
initcond = '{0,0}'
106106
);

‎doc/src/sgml/xfunc.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/xfunc.sgml,v 1.21 2000/09/29 20:21:34 petere Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/xfunc.sgml,v 1.22 2000/10/23 00:46:06 tgl Exp $
33
-->
44

55
<chapter id="xfunc">
@@ -108,7 +108,7 @@ SELECT tp1( 17,100.0);
108108
EMP, and retrieves multiple results:
109109

110110
<programlisting>
111-
CREATE FUNCTION hobbies (EMP) RETURNS SET OF hobbies
111+
CREATE FUNCTION hobbies (EMP) RETURNS SETOF hobbies
112112
AS 'SELECT hobbies.* FROM hobbies
113113
WHERE $1.name = hobbies.person'
114114
LANGUAGE 'sql';

0 commit comments

Comments
 (0)