Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitc82c955

Browse files
committed
Minor updates/corrections for CREATE/DROP FUNCTION/AGGREGATE/OPERATOR.
1 parent9ace031 commitc82c955

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) RETURNSSET OF hobbies
111+
CREATE FUNCTION hobbies (EMP) RETURNSSETOF hobbies
112112
AS 'SELECT hobbies.* FROM hobbies
113113
WHERE $1.name = hobbies.person'
114114
LANGUAGE 'sql';

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp