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

Commitb6bdc43

Browse files
author
Thomas G. Lockhart
committed
Add new reference pages. This completes the first cut at a full set
 for SQL commands.
1 parent2027519 commitb6bdc43

13 files changed

+2340
-5
lines changed

‎doc/src/sgml/ref/commands.sgml

Lines changed: 18 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,8 @@
1-
<chapter Id="sql-commands">
2-
<title>Commands</title>
1+
<Chapter>
2+
<Title>Commands</Title>
33

4-
<para>
5-
</para>
4+
<Para>
5+
</Para>
66

77
&alterTable;
88
&alterUser;
@@ -26,7 +26,19 @@
2626
&createView;
2727
&declare;
2828
&delete;
29+
&dropAggregate;
30+
&dropDatabase;
2931
&dropFunction;
32+
&dropIndex;
33+
&dropLanguage;
34+
&dropOperator;
35+
&dropRule;
36+
&dropSequence;
37+
&dropTable;
38+
&dropTrigger;
39+
&dropType
40+
&dropUser;
41+
&dropView;
3042
&explain;
3143
&fetch;
3244
&grant;
@@ -44,7 +56,7 @@
4456
&show;
4557
&update;
4658

47-
</chapter>
59+
</Chapter>
4860

4961
<chapter Id="sql-functions">
5062
<title>SQL Functions</title>
@@ -59,6 +71,7 @@
5971

6072
</chapter>
6173

74+
6275
<!-- Keep this comment at the end of the file
6376
Local variables:
6477
mode: sgml

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

Lines changed: 193 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,193 @@
1+
<REFENTRY ID="SQL-DROPAGGREGATE">
2+
<REFMETA>
3+
<REFENTRYTITLE>
4+
DROP AGGREGATE
5+
</REFENTRYTITLE>
6+
<REFMISCINFO>SQL - Language Statements</REFMISCINFO>
7+
</REFMETA>
8+
<REFNAMEDIV>
9+
<REFNAME>
10+
DROP AGGREGATE
11+
</REFNAME>
12+
<REFPURPOSE>
13+
Removes the definition of an aggregate function
14+
</REFPURPOSE>
15+
<REFSYNOPSISDIV>
16+
<REFSYNOPSISDIVINFO>
17+
<DATE>1998-04-15</DATE>
18+
</REFSYNOPSISDIVINFO>
19+
<SYNOPSIS>
20+
DROP AGGREGATE <REPLACEABLE CLASS="PARAMETER">name</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">type</REPLACEABLE>
21+
</SYNOPSIS>
22+
23+
<REFSECT2 ID="R2-SQL-DROPAGGREGATE-1">
24+
<REFSECT2INFO>
25+
<DATE>1998-04-15</DATE>
26+
</REFSECT2INFO>
27+
<TITLE>
28+
Inputs
29+
</TITLE>
30+
<PARA>
31+
</PARA>
32+
<VARIABLELIST>
33+
<VARLISTENTRY>
34+
<TERM>
35+
</TERM>
36+
<LISTITEM>
37+
<PARA>
38+
<VARIABLELIST>
39+
<VARLISTENTRY>
40+
<TERM>
41+
<ReturnValue><replaceable class="parameter">name</replaceable></ReturnValue>
42+
</TERM>
43+
<LISTITEM>
44+
<PARA>
45+
The name of an existing aggregate function.
46+
</PARA>
47+
</LISTITEM>
48+
</VARLISTENTRY>
49+
<VARLISTENTRY>
50+
<TERM>
51+
<ReturnValue><replaceable class="parameter">type</replaceable></ReturnValue>
52+
</TERM>
53+
<LISTITEM>
54+
<PARA>
55+
The type of an existing aggregate function.
56+
(Refer to PostgreSQL User's Guide chapter 4 for
57+
further information about data types).
58+
<comment>This should become a cross-reference rather than a
59+
hard-coded chapter number</comment>
60+
</PARA>
61+
</LISTITEM>
62+
</VARLISTENTRY>
63+
</variablelist>
64+
</LISTITEM>
65+
</VARLISTENTRY>
66+
</VARIABLELIST>
67+
</REFSECT2>
68+
69+
<REFSECT2 ID="R2-SQL-DROPAGGREGATE-2">
70+
<REFSECT2INFO>
71+
<DATE>1998-04-15</DATE>
72+
</REFSECT2INFO>
73+
<TITLE>
74+
Outputs
75+
</TITLE>
76+
<PARA>
77+
</PARA>
78+
<VARIABLELIST>
79+
<VARLISTENTRY>
80+
<TERM>
81+
</TERM>
82+
<LISTITEM>
83+
<PARA>
84+
<VARIABLELIST>
85+
<VARLISTENTRY>
86+
<TERM>
87+
<ReturnValue>DROP</ReturnValue>
88+
</TERM>
89+
<LISTITEM>
90+
<PARA>
91+
Message returned if the command is successful.
92+
</PARA>
93+
</LISTITEM>
94+
</VARLISTENTRY>
95+
<VARLISTENTRY>
96+
<TERM>
97+
<ReturnValue>WARN RemoveAggregate: aggregate '<replaceable class="parameter">name</replaceable>' for 'type' does not exist</ReturnValue>
98+
</TERM>
99+
<LISTITEM>
100+
<PARA>
101+
This message occurs if the aggregate function specified does not
102+
exist in the database.
103+
</PARA>
104+
</LISTITEM>
105+
</VARLISTENTRY>
106+
</variablelist>
107+
</LISTITEM>
108+
</VARLISTENTRY>
109+
</VARIABLELIST>
110+
</REFSECT2>
111+
</REFSYNOPSISDIV>
112+
113+
<REFSECT1 ID="R1-SQL-DROPAGGREGATE-1">
114+
<REFSECT1INFO>
115+
<DATE>1998-04-15</DATE>
116+
</REFSECT1INFO>
117+
<TITLE>
118+
Description
119+
</TITLE>
120+
<PARA>
121+
<command>DROP AGGREGATE</command> will remove all references to an existing
122+
aggregate definition. To execute this command the current
123+
user must be the owner of the aggregate.
124+
</PARA>
125+
126+
<REFSECT2 ID="R2-SQL-DROPAGGREGATE-3">
127+
<REFSECT2INFO>
128+
<DATE>1998-04-15</DATE>
129+
</REFSECT2INFO>
130+
<TITLE>
131+
Notes
132+
</TITLE>
133+
<PARA>
134+
The <command>DROP AGGREGATE</command> statement is a PostgreSQL
135+
language extension.
136+
</PARA>
137+
<PARA>
138+
Refer to the <command>CREATE AGGREGATE</command> statement to
139+
create aggregate functions.
140+
</PARA>
141+
</REFSECT2>
142+
</REFSECT1>
143+
144+
<REFSECT1 ID="R1-SQL-DROPAGGREGATE-2">
145+
<TITLE>
146+
Usage
147+
</TITLE>
148+
<PARA>
149+
To remove the <literal>myavg</literal> aggregate for type
150+
<literal>int4</literal>:
151+
</PARA>
152+
<ProgramListing>
153+
DROP AGGREGATE myavg int4;
154+
</ProgramListing>
155+
</REFSECT1>
156+
157+
<REFSECT1 ID="R1-SQL-DROPAGGREGATE-3">
158+
<TITLE>
159+
Compatibility
160+
</TITLE>
161+
<PARA>
162+
</PARA>
163+
164+
<REFSECT2 ID="R2-SQL-DROPAGGREGATE-4">
165+
<REFSECT2INFO>
166+
<DATE>1998-04-15</DATE>
167+
</REFSECT2INFO>
168+
<TITLE>
169+
SQL92
170+
</TITLE>
171+
<PARA>
172+
There is no DROP AGGREGATE statement in SQL92.
173+
</PARA>
174+
</refsect2>
175+
</refsect1>
176+
</REFENTRY>
177+
178+
<!-- Keep this comment at the end of the file
179+
Local variables:
180+
mode: sgml
181+
sgml-omittag:t
182+
sgml-shorttag:t
183+
sgml-minimize-attributes:nil
184+
sgml-always-quote-attributes:t
185+
sgml-indent-step:1
186+
sgml-indent-data:t
187+
sgml-parent-document:nil
188+
sgml-default-dtd-file:"../reference.ced"
189+
sgml-exposed-tags:nil
190+
sgml-local-catalogs:"/usr/lib/sgml/catalog"
191+
sgml-local-ecat-files:nil
192+
End:
193+
-->

0 commit comments

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