From ba36c48e39747678412d48bcbf6ed14cb2dc8ddf Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 27 Apr 2009 16:27:36 +0000 Subject: Proofreading adjustments for first two parts of documentation (Tutorial and SQL). --- doc/src/sgml/syntax.sgml | 64 ++++++++++++++++++++++++------------------------ 1 file changed, 32 insertions(+), 32 deletions(-) (limited to 'doc/src/sgml/syntax.sgml') diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index 744a13ef478..48bf5a4feb8 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -1,4 +1,4 @@ - + SQL Syntax @@ -11,12 +11,12 @@ This chapter describes the syntax of SQL. It forms the foundation for understanding the following chapters which will go into detail - about how the SQL commands are applied to define and modify data. + about how SQL commands are applied to define and modify data. We also advise users who are already familiar with SQL to read this - chapter carefully because there are several rules and concepts that + chapter carefully because it contains several rules and concepts that are implemented inconsistently among SQL databases or that are specific to PostgreSQL. @@ -293,7 +293,7 @@ U&"d!0061t!+000061" UESCAPE '!' bounded by single quotes ('), for example 'This is a string'. To include a single-quote character within a string constant, - write two adjacent single quotes, e.g. + write two adjacent single quotes, e.g., 'Dianne''s horse'. Note that this is not the same as a double-quote character ("). @@ -337,7 +337,7 @@ SELECT 'foo' 'bar'; string constants, which are an extension to the SQL standard. An escape string constant is specified by writing the letter E (upper or lower case) just before the opening single - quote, e.g. E'foo'. (When continuing an escape string + quote, e.g., E'foo'. (When continuing an escape string constant across lines, write E only before the first opening quote.) Within an escape string, a backslash character (\) begins a @@ -422,14 +422,14 @@ SELECT 'foo' 'bar'; is off, then PostgreSQL recognizes backslash escapes in both regular and escape string constants. This is for backward - compatibility with the historical behavior, in which backslash escapes + compatibility with the historical behavior, where backslash escapes were always recognized. Although standard_conforming_strings currently defaults to off, the default will change to on in a future release for improved standards compliance. Applications are therefore encouraged to migrate away from using backslash escapes. If you need to use a backslash escape to represent a special character, write the - constant with an E to be sure it will be handled the same + string constant with an E to be sure it will be handled the same way in future releases. @@ -442,7 +442,7 @@ SELECT 'foo' 'bar'; - The character with the code zero cannot be in a string constant. + The zero-byte (null byte) character cannot be in a string constant. @@ -896,7 +896,7 @@ CAST ( 'string' AS type ) - A comment is an arbitrary sequence of characters beginning with + A comment is a sequence of characters beginning with double dashes and extending to the end of the line, e.g.: -- This is a standard SQL comment @@ -918,8 +918,8 @@ CAST ( 'string' AS type ) - A comment is removed from the input stream before further syntax - analysis and is effectively replaced by whitespace. + Comment are removed from the input stream before further syntax + analysis and are effectively replaced by whitespace. @@ -1112,7 +1112,7 @@ SELECT 3 OPERATOR(pg_catalog.+) 4; the OPERATOR construct is taken to have the default precedence shown in for any other operator. This is true no matter - which specific operator name appears inside OPERATOR(). + which specific operator appears inside OPERATOR(). @@ -1154,80 +1154,80 @@ SELECT 3 OPERATOR(pg_catalog.+) 4; - A constant or literal value. + A constant or literal value - A column reference. + A column reference A positional parameter reference, in the body of a function definition - or prepared statement. + or prepared statement - A subscripted expression. + A subscripted expression - A field selection expression. + A field selection expression - An operator invocation. + An operator invocation - A function call. + A function call - An aggregate expression. + An aggregate expression - A window function call. + A window function call - A type cast. + A type cast - A scalar subquery. + A scalar subquery - An array constructor. + An array constructor - A row constructor. + A row constructor @@ -1264,7 +1264,7 @@ SELECT 3 OPERATOR(pg_catalog.+) 4; - A column can be referenced in the form + A column can be referenced in the form: correlation.columnname @@ -1426,7 +1426,7 @@ $1.somecolumn where the operator token follows the syntax rules of , or is one of the key words AND, OR, and - NOT, or is a qualified operator name in the form + NOT, or is a qualified operator name in the form: OPERATOR(schema.operatorname) @@ -1714,7 +1714,7 @@ CAST ( expression AS type casts that are marked OK to apply implicitly in the system catalogs. Other casts must be invoked with explicit casting syntax. This restriction is intended to prevent - surprising conversions from being applied silently. + surprising conversions from being silently applied. @@ -1730,7 +1730,7 @@ CAST ( expression AS type timestamp can only be used in this fashion if they are double-quoted, because of syntactic conflicts. Therefore, the use of the function-like cast syntax leads to inconsistencies and should - probably be avoided in new applications. + probably be avoided. @@ -1794,7 +1794,7 @@ SELECT name, (SELECT max(pop) FROM cities WHERE cities.state = states.name) An array constructor is an expression that builds an - array value from values for its member elements. A simple array + array using values for its member elements. A simple array constructor consists of the key word ARRAY, a left square bracket [, a list of expressions (separated by commas) for the @@ -1925,8 +1925,8 @@ SELECT ARRAY(SELECT oid FROM pg_proc WHERE proname LIKE 'bytea%'); - A row constructor is an expression that builds a row value (also - called a composite value) from values + A row constructor is an expression that builds a row (also + called a composite value) using values for its member fields. A row constructor consists of the key word ROW, a left parenthesis, zero or more expressions (separated by commas) for the row field values, and finally -- cgit v1.2.3