Skip to content

Commit d1b4327

Browse files
peterepetere
committed
Last round of reference page editing.
1 parent ac5fdea commit d1b4327

31 files changed

+3240
-4452
lines changed

‎doc/src/sgml/ref/declare.sgml

Lines changed: 228 additions & 297 deletions
Large diffs are not rendered by default.

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

Lines changed: 104 additions & 145 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.21 2003/03/25 16:15:39 petere Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_aggregate.sgml,v 1.22 2003/05/04 02:23:16 petere Exp $
33
PostgreSQL documentation
44
-->
55

@@ -8,167 +8,126 @@ PostgreSQL documentation
88
<refentrytitle id="SQL-DROPAGGREGATE-TITLE">DROP AGGREGATE</refentrytitle>
99
<refmiscinfo>SQL - Language Statements</refmiscinfo>
1010
</refmeta>
11+
1112
<refnamediv>
12-
<refname>
13-
DROP AGGREGATE
14-
</refname>
15-
<refpurpose>
16-
remove a user-defined aggregate function
17-
</refpurpose>
13+
<refname>DROP AGGREGATE</refname>
14+
<refpurpose>remove a user-defined aggregate function</refpurpose>
1815
</refnamediv>
16+
1917
<refsynopsisdiv>
20-
<refsynopsisdivinfo>
21-
<date>1999-07-20</date>
22-
</refsynopsisdivinfo>
23-
<synopsis>
18+
<synopsis>
2419
DROP AGGREGATE <replaceable class="PARAMETER">name</replaceable> ( <replaceable class="PARAMETER">type</replaceable> ) [ CASCADE | RESTRICT ]
25-
</synopsis>
26-
27-
<refsect2 id="R2-SQL-DROPAGGREGATE-1">
28-
<refsect2info>
29-
<date>1998-04-15</date>
30-
</refsect2info>
31-
<title>
32-
Inputs
33-
</title>
34-
<para>
35-
<variablelist>
36-
<varlistentry>
37-
<term><replaceable class="parameter">name</replaceable></term>
38-
<listitem>
39-
<para>
40-
The name (optionally schema-qualified) of an existing aggregate function.
41-
</para>
42-
</listitem>
43-
</varlistentry>
44-
<varlistentry>
45-
<term><replaceable class="parameter">type</replaceable></term>
46-
<listitem>
47-
<para>
48-
The input data type of the aggregate function,
49-
or <literal>*</literal> if the function accepts any input type.
50-
</para>
51-
</listitem>
52-
</varlistentry>
53-
<varlistentry>
54-
<term>CASCADE</term>
55-
<listitem>
56-
<para>
57-
Automatically drop objects that depend on the aggregate.
58-
</para>
59-
</listitem>
60-
</varlistentry>
61-
<varlistentry>
62-
<term>RESTRICT</term>
63-
<listitem>
64-
<para>
65-
Refuse to drop the aggregate if there are any dependent objects.
66-
This is the default.
67-
</para>
68-
</listitem>
69-
</varlistentry>
70-
</variablelist>
71-
</para>
72-
</refsect2>
73-
74-
<refsect2 id="R2-SQL-DROPAGGREGATE-2">
75-
<refsect2info>
76-
<date>1998-04-15</date>
77-
</refsect2info>
78-
<title>
79-
Outputs
80-
</title>
81-
<para>
82-
<variablelist>
83-
<varlistentry>
84-
<term><computeroutput>
85-
DROP AGGREGATE
86-
</computeroutput></term>
87-
<listitem>
88-
<para>
89-
Message returned if the command is successful.
90-
</para>
91-
</listitem>
92-
</varlistentry>
93-
<varlistentry>
94-
<term><computeroutput>
95-
ERROR: RemoveAggregate: aggregate '<replaceable class="parameter">name</replaceable>' for type <replaceable class="parameter">type</replaceable> does not exist
96-
</computeroutput></term>
97-
<listitem>
98-
<para>
99-
This message occurs if the aggregate function specified does not
100-
exist in the database.
101-
</para>
102-
</listitem>
103-
</varlistentry>
104-
</variablelist>
105-
</para>
106-
</refsect2>
20+
</synopsis>
10721
</refsynopsisdiv>
10822

109-
<refsect1 id="R1-SQL-DROPAGGREGATE-1">
110-
<refsect1info>
111-
<date>1998-04-15</date>
112-
</refsect1info>
113-
<title>
114-
Description
115-
</title>
23+
<refsect1>
24+
<title>Description</title>
25+
11626
<para>
11727
<command>DROP AGGREGATE</command> will delete an existing
118-
aggregate definition. To execute this command the current
119-
user must be the owner of the aggregate.
28+
aggregate function. To execute this command the current
29+
user must be the owner of the aggregate function.
12030
</para>
31+
</refsect1>
32+
33+
<refsect1>
34+
<title>Parameters</title>
35+
36+
<variablelist>
37+
<varlistentry>
38+
<term><replaceable class="parameter">name</replaceable></term>
39+
<listitem>
40+
<para>
41+
The name (optionally schema-qualified) of an existing aggregate function.
42+
</para>
43+
</listitem>
44+
</varlistentry>
45+
46+
<varlistentry>
47+
<term><replaceable class="parameter">type</replaceable></term>
48+
<listitem>
49+
<para>
50+
The argument data type of the aggregate function, or
51+
<literal>*</literal> if the function accepts any data type.
52+
</para>
53+
</listitem>
54+
</varlistentry>
55+
56+
<varlistentry>
57+
<term><literal>CASCADE</literal></term>
58+
<listitem>
59+
<para>
60+
Automatically drop objects that depend on the aggregate function.
61+
</para>
62+
</listitem>
63+
</varlistentry>
64+
65+
<varlistentry>
66+
<term><literal>RESTRICT</literal></term>
67+
<listitem>
68+
<para>
69+
Refuse to drop the aggregate function if any objects depend on
70+
it. This is the default.
71+
</para>
72+
</listitem>
73+
</varlistentry>
74+
</variablelist>
75+
</refsect1>
12176

122-
<refsect2 id="R2-SQL-DROPAGGREGATE-3">
123-
<refsect2info>
124-
<date>1998-04-15</date>
125-
</refsect2info>
126-
<title>
127-
Notes
128-
</title>
129-
130-
<para>
131-
Use
132-
<xref linkend="sql-createaggregate" endterm="sql-createaggregate-title">
133-
to create aggregate functions.
134-
</para>
135-
</refsect2>
77+
<refsect1>
78+
<title>Diagnostics</title>
79+
80+
<variablelist>
81+
<varlistentry>
82+
<term><computeroutput>DROP AGGREGATE</computeroutput></term>
83+
<listitem>
84+
<para>
85+
Message returned if the command was successful.
86+
</para>
87+
</listitem>
88+
</varlistentry>
89+
90+
<varlistentry>
91+
<term><computeroutput>ERROR: RemoveAggregate: aggregate '<replaceable class="parameter">name</replaceable>' for type <replaceable class="parameter">type</replaceable> does not exist</computeroutput></term>
92+
<listitem>
93+
<para>
94+
This message is returned if the specified aggregate function
95+
does not exist.
96+
</para>
97+
</listitem>
98+
</varlistentry>
99+
</variablelist>
100+
</refsect1>
101+
102+
<refsect1>
103+
<title>Examples</title>
104+
105+
<para>
106+
To remove the aggregate function <literal>myavg</literal> for type
107+
<type>integer</type>:
108+
<programlisting>
109+
DROP AGGREGATE myavg(integer);
110+
</programlisting>
111+
</para>
136112
</refsect1>
137113

138-
<refsect1 id="R1-SQL-DROPAGGREGATE-2">
139-
<title>
140-
Usage
141-
</title>
114+
<refsect1>
115+
<title>Compatibility</title>
116+
142117
<para>
143-
To remove the <literal>myavg</literal> aggregate for type
144-
<literal>int4</literal>:
118+
There is no <command>DROP AGGREGATE</command> statement in the SQL
119+
standard.
145120
</para>
146-
<programlisting>
147-
DROP AGGREGATE myavg(int4);
148-
</programlisting>
149121
</refsect1>
150122

151-
<refsect1 id="R1-SQL-DROPAGGREGATE-3">
152-
<title>
153-
Compatibility
154-
</title>
155-
156-
<refsect2 id="R2-SQL-DROPAGGREGATE-4">
157-
<refsect2info>
158-
<date>1998-04-15</date>
159-
</refsect2info>
160-
<title>
161-
SQL92
162-
</title>
163-
164-
<para>
165-
There is no <command>DROP AGGREGATE</command> statement
166-
in <acronym>SQL92</acronym>; the statement is a
167-
<productname>PostgreSQL</productname>
168-
language extension.
169-
</para>
170-
</refsect2>
123+
<refsect1>
124+
<title>See Also</title>
125+
126+
<simplelist type="inline">
127+
<member><xref linkend="sql-createaggregate" endterm="sql-createaggregate-title"></member>
128+
</simplelist>
171129
</refsect1>
130+
172131
</refentry>
173132

174133
<!-- Keep this comment at the end of the file

‎doc/src/sgml/ref/drop_cast.sgml

Lines changed: 12 additions & 23 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_cast.sgml,v 1.2 2002/08/11 17:44:12 petere Exp $ -->
1+
<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_cast.sgml,v 1.3 2003/05/04 02:23:16 petere Exp $ -->
22

33
<refentry id="SQL-DROPCAST">
44
<refmeta>
@@ -13,8 +13,7 @@
1313

1414
<refsynopsisdiv>
1515
<synopsis>
16-
DROP CAST (<replaceable>sourcetype</replaceable> AS <replaceable>targettype</replaceable>)
17-
[ CASCADE | RESTRICT ]
16+
DROP CAST (<replaceable>sourcetype</replaceable> AS <replaceable>targettype</replaceable>) [ CASCADE | RESTRICT ]
1817
</synopsis>
1918
</refsynopsisdiv>
2019

@@ -30,10 +29,12 @@ DROP CAST (<replaceable>sourcetype</replaceable> AS <replaceable>targettype</rep
3029
data type. These are the same privileges that are required to
3130
create a cast.
3231
</para>
32+
</refsect1>
3333

34-
<variablelist>
35-
<title>Parameters</title>
34+
<refsect1>
35+
<title>Parameters</title>
3636

37+
<variablelist>
3738
<varlistentry>
3839
<term><replaceable>sourcetype</replaceable></term>
3940

@@ -66,45 +67,33 @@ DROP CAST (<replaceable>sourcetype</replaceable> AS <replaceable>targettype</rep
6667
</listitem>
6768
</varlistentry>
6869
</variablelist>
69-
70-
</refsect1>
71-
72-
<refsect1 id="sql-dropcast-notes">
73-
<title>Notes</title>
74-
75-
<para>
76-
Use <command>CREATE CAST</command> to create user-defined casts.
77-
</para>
7870
</refsect1>
7971

80-
8172
<refsect1 id="sql-dropcast-examples">
8273
<title>Examples</title>
8374

8475
<para>
8576
To drop the cast from type <type>text</type> to type <type>int</type>:
8677
<programlisting>
87-
DROP CAST (text AS int4);
78+
DROP CAST (text AS int);
8879
</programlisting>
8980
</para>
9081
</refsect1>
91-
9282

9383
<refsect1 id="sql-dropcast-compat">
9484
<title>Compatibility</title>
9585

9686
<para>
97-
The <command>DROP CAST</command> command conforms to SQL99.
87+
The <command>DROP CAST</command> command conforms to the SQL standard.
9888
</para>
9989
</refsect1>
10090

101-
102-
<refsect1 id="sql-dropcast-seealso">
91+
<refsect1>
10392
<title>See Also</title>
10493

105-
<para>
106-
<xref linkend="sql-createcast" endterm="sql-createcast-title">
107-
</para>
94+
<simplelist type="inline">
95+
<member><xref linkend="sql-createcast" endterm="sql-createcast-title"></member>
96+
</simplelist>
10897
</refsect1>
10998

11099
</refentry>

0 commit comments

Comments
 (0)