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

Commitd1b4327

Browse files
committed
Last round of reference page editing.
1 parentac5fdea commitd1b4327

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-
aggregatedefinition. To execute this command the current
119-
user must be the owner of the aggregate.
28+
aggregatefunction. 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 ASint4);
78+
DROP CAST (text ASint);
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 toSQL99.
87+
The <command>DROP CAST</command> command conforms tothe 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)
[8]ページ先頭
©2009-2025 Movatter.jp