Skip to content

Commit 4835f6a

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 parent b0f52ab commit 4835f6a

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/14 13:12:52 thomas Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.56 2000/07/14 15: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 INTO INOUT IS
139139
JOIN
140140
LEADING LEFT LIKE LOCAL
141141
NAMES NATIONAL NATURAL NCHAR NO NOT NULL
142-
ON OR OUTER
142+
ON OR OUT OUTER
143143
PARTIAL PRIMARY PRIVILEGES PROCEDURE PUBLIC
144144
REFERENCES REVOKE RIGHT ROLLBACK
145-
SELECT SET SUBSTRING
145+
SELECT SESSION SET SUBSTRING
146146
TO TRAILING TRIM
147147
UNION UNIQUE UPDATE USING
148148
VALUES VARCHAR VARYING VIEW
149-
WHERE WITH WORK
149+
WHERE WITH WITHOUT WORK
150150
</programlisting>
151151
</para>
152152

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

281281
<programlisting>
282282
ABSOLUTE ACTION
283-
CONSTRAINTS
283+
CHARACTERISTICS CONSTRAINTS
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+
PATH PENDANT PRIOR PRIVILEGES
293293
READ RELATIVE RESTRICT
294-
SCROLL SECOND
294+
SCHEMA SCROLL 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)