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

Commit4835f6a

Browse files
author
Thomas G. Lockhart
committed
Update docs for TIME WITHOUT TIME ZONE.
Add information on SET SESSION CHARACTERISTICS.Fix references to pg_hba.conf(5) since that is no longer a man page.
1 parentb0f52ab commit4835f6a

File tree

5 files changed

+96
-30
lines changed

5 files changed

+96
-30
lines changed

‎doc/src/sgml/datatype.sgml‎

Lines changed: 12 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.30 2000/05/02 20:01:51 thomas Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.31 2000/07/14 15:26:21 thomas Exp $
33
-->
44

55
<chapter id="datatype">
@@ -159,7 +159,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.30 2000/05/02 20:01:51 th
159159
</row>
160160
<row>
161161
<entry>time</entry>
162-
<entry>time</entry>
162+
<entry>time [ without time zone ]</entry>
163163
<entry>time of day</entry>
164164
</row>
165165
<row>
@@ -169,7 +169,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.30 2000/05/02 20:01:51 th
169169
</row>
170170
<row>
171171
<entry>timestamp</entry>
172-
<entry>timestamp with time zone</entry>
172+
<entry>timestamp[with time zone ]</entry>
173173
<entry>date/time</entry>
174174
</row>
175175
<row>
@@ -581,7 +581,7 @@ CREATE TABLE <replaceable class="parameter">tablename</replaceable> (<replaceabl
581581
<entry>1 microsec / 14 digits</entry>
582582
</row>
583583
<row>
584-
<entry><type>timestamp with time zone</type></entry>
584+
<entry><type>timestamp[with time zone ]</type></entry>
585585
<entry>date and time with time zone</entry>
586586
<entry>8 bytes</entry>
587587
<entry>1903 AD</entry>
@@ -605,7 +605,7 @@ CREATE TABLE <replaceable class="parameter">tablename</replaceable> (<replaceabl
605605
<entry>1 day</entry>
606606
</row>
607607
<row>
608-
<entry><type>time</type></entry>
608+
<entry><type>time [ without time zone ]</type></entry>
609609
<entry>times of day only</entry>
610610
<entry>4 bytes</entry>
611611
<entry>00:00:00.00</entry>
@@ -843,7 +843,13 @@ CREATE TABLE <replaceable class="parameter">tablename</replaceable> (<replaceabl
843843
</sect3>
844844

845845
<sect3>
846-
<title>time</title>
846+
<title>time [ without time zone ]</title>
847+
848+
<para>
849+
Per SQL99, this type can be referenced as <type>time</type> and
850+
as <type>time without time zone</type>.
851+
</para>
852+
847853
<para>
848854
The following are valid <type>time</type> inputs.
849855

‎doc/src/sgml/func.sgml‎

Lines changed: 6 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -1527,7 +1527,6 @@ Not defined by this name. Implements the intersection operator '#'
15271527
</sect1>
15281528

15291529
<sect1>
1530-
15311530
<title id="aggregate-funcs">Aggregate Functions</title>
15321531

15331532
<note>
@@ -1542,13 +1541,14 @@ Not defined by this name. Implements the intersection operator '#'
15421541
<firstterm>Aggregate functions</firstterm> allow the generation of simple
15431542
statistics about the values of particular columns over the selected set
15441543
of rows.
1545-
See also the chapter on aggregates in
1546-
<citetitle>The PostgreSQL Tutorial</citetitle>
15471544
<!--
1548-
<xref linkend="sql" endterm="aggregates-tutorial">
1549-
-->
1550-
and
1545+
See also <xref linkend="sql" endterm="aggregates-tutorial"> and
15511546
<xref linkend="syntax" endterm="aggregates-syntax">.
1547+
-->
1548+
See also <xref linkend="syntax" endterm="aggregates-syntax">;
1549+
refer to
1550+
the <citetitle>PostgreSQL Tutorial</citetitle> for additional
1551+
introductory information.
15521552
</para>
15531553

15541554
<para>
@@ -1612,7 +1612,6 @@ Not defined by this name. Implements the intersection operator '#'
16121612
</table>
16131613
</para>
16141614
</sect1>
1615-
16161615
</chapter>
16171616

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

‎doc/src/sgml/protocol.sgml‎

Lines changed: 3 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -49,7 +49,9 @@ have different roles but may be implemented by the same executable.
4949
<Para>
5050
A frontend sends a startup packet to the postmaster. This includes the names
5151
of the user and the database the user wants to connect to. The postmaster then
52-
uses this, and the information in the pg_hba.conf(5) file to determine what
52+
uses this, and the information in the <filename>pg_hba.conf</filename>
53+
file
54+
to determine what
5355
further authentication information it requires the frontend to send (if any)
5456
and responds to the frontend accordingly.
5557
</para>

‎doc/src/sgml/release.sgml‎

Lines changed: 58 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,10 +1,65 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.55 2000/06/1413:12:52 thomas Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.56 2000/07/1415:26:21 thomas Exp $
33
-->
44

55
<chapter id="release">
66
<title>Release Notes</title>
77

8+
<sect1>
9+
<title>Release 7.1</title>
10+
<!--
11+
<docinfo>
12+
<authorgroup>
13+
<author>
14+
<firstname>Bruce</firstname>
15+
<surname>Momjian</surname>
16+
</author>
17+
</authorgroup>
18+
<date>2000-07-13</date>
19+
</docinfo>
20+
-->
21+
22+
<para>
23+
Release date 2000-xx-xx.
24+
25+
<para>
26+
Major changes in this release:
27+
28+
<variablelist>
29+
<varlistentry>
30+
<term>
31+
Nested block comments
32+
</term>
33+
<listitem>
34+
<para>
35+
SQL99 defines C-style block comments, and allows them to be nested.
36+
</para>
37+
</listitem>
38+
</varlistentry>
39+
</para>
40+
41+
<sect2>
42+
<title>Migration to v7.1</title>
43+
44+
<para>
45+
A dump/restore is required for those running any previous version.
46+
</para>
47+
</sect2>
48+
49+
<sect2>
50+
<title>Changes</title>
51+
52+
<para>
53+
<programlisting>
54+
Implement WITHOUT TIME ZONE date/time type qualifier per SQL99 (Thomas)
55+
Implement nested block comments per SQL99 (Thomas)
56+
Implement SET SESSION CHARACTERISTICS per SQL99 (Thomas)
57+
Set session-wide transaction mode READ COMMITTED or SERIALIZABLE (Thomas)
58+
</programlisting>
59+
</para>
60+
</sect2>
61+
</sect1>
62+
863
<sect1>
964
<title>Release 7.0.2</title>
1065
<!--
@@ -1872,7 +1927,8 @@ Better identify tcl and tk libs and includes(Bruce)
18721927
</para>
18731928
<para>
18741929
We now have passwords definable independent of any Unix file. There are
1875-
new SQL USER commands. See the pg_hba.conf manual page for more
1930+
new SQL USER commands.
1931+
See the <citetitle>Administrator's Guide</citetitle> for more
18761932
information. There is a new table, pg_shadow, which is used to store
18771933
user information and user passwords, and it by default only SELECT-able
18781934
by the postgres super-user. pg_user is now a view of pg_shadow, and is

‎doc/src/sgml/syntax.sgml‎

Lines changed: 17 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/syntax.sgml,v 1.22 2000/06/20 18:04:18 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/syntax.sgml,v 1.23 2000/07/14 15:26:21 thomas Exp $
33
-->
44

55
<chapter id="syntax">
@@ -135,18 +135,18 @@ EXECUTE EXISTS EXTRACT
135135
FETCH FLOAT FOR FROM FULL
136136
GRANT
137137
HAVING
138-
IN INNER INSERT INTERVAL INTO IS
138+
IN INNER INSERT INTERVAL INTOINOUTIS
139139
JOIN
140140
LEADING LEFT LIKE LOCAL
141141
NAMES NATIONAL NATURAL NCHAR NO NOT NULL
142-
ON OR OUTER
142+
ON OROUTOUTER
143143
PARTIAL PRIMARY PRIVILEGES PROCEDURE PUBLIC
144144
REFERENCES REVOKE RIGHT ROLLBACK
145-
SELECT SET SUBSTRING
145+
SELECTSESSIONSET SUBSTRING
146146
TO TRAILING TRIM
147147
UNION UNIQUE UPDATE USING
148148
VALUES VARCHAR VARYING VIEW
149-
WHERE WITH WORK
149+
WHERE WITHWITHOUTWORK
150150
</programlisting>
151151
</para>
152152

@@ -280,7 +280,7 @@ VALID VERSION
280280

281281
<programlisting>
282282
ABSOLUTE ACTION
283-
CONSTRAINTS
283+
CHARACTERISTICSCONSTRAINTS
284284
DAY DEFERRABLE DEFERRED
285285
HOUR
286286
IMMEDIATE INITIALLY INSENSITIVE ISOLATION
@@ -289,9 +289,9 @@ LANGUAGE LEVEL
289289
MATCH MINUTE MONTH
290290
NEXT
291291
OF ONLY OPTION
292-
PENDANT PRIOR PRIVILEGES
292+
PATHPENDANT PRIOR PRIVILEGES
293293
READ RELATIVE RESTRICT
294-
SCROLL SECOND
294+
SCHEMASCROLL SECOND
295295
TIME TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE TRIGGER
296296
YEAR
297297
ZONE
@@ -349,18 +349,21 @@ UNCOMMITTED UNNAMED
349349
<programlisting>
350350
-- This is a standard SQL comment
351351
</programlisting>
352+
</para>
352353

353-
We also support C-style block comments, e.g.:
354+
<para>
355+
We also support C-style block comments, e.g.:
354356

355357
<programlisting>
356-
/* multi
357-
line
358-
comment
358+
/* multi-line comment
359+
* with nesting: /* nested block comment */
359360
*/
360361
</programlisting>
361362

362-
A comment beginning with "/*" extends to the first occurrence of "*/".
363-
363+
where the comment begins with "<literal>/*</literal>" and extends
364+
to the first occurrence of "<literal>*/</literal>". These block
365+
comments nest, as specified in SQL99, so that one can comment out
366+
larger blocks of code which may contain existing block comments.
364367
</para>
365368
</sect1>
366369

0 commit comments

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