diff options
| author | Bruce Momjian <bruce@momjian.us> | 2010-08-11 21:49:01 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2010-08-11 21:49:01 +0000 |
| commit | f483b02041aaa5e1df055706296096ef00dac47f (patch) | |
| tree | 39befe60db7ca81219c9fb44ed8cce840b1c74c4 /doc/src | |
| parent | e286b85c90d2197b9eaa2dc6d0b2b67795ba7ab9 (diff) | |
Properly lowercase identifiers, uppercase keywords, in doc examples
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/syntax.sgml | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index a86fa26c306..88a4f8edb5e 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/syntax.sgml,v 1.147.2.2 2010/08/05 18:21:29 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/syntax.sgml,v 1.147.2.3 2010/08/11 21:49:01 momjian Exp $ --> <chapter id="sql-syntax"> <title>SQL Syntax</title> @@ -56,9 +56,9 @@ <para> For example, the following is (syntactically) valid SQL input: <programlisting> -SELECT * FROM MY_TABLE; -UPDATE MY_TABLE SET A = 5; -INSERT INTO MY_TABLE VALUES (3, 'hi there'); +SELECT * FROM my_table; +UPDATE my_table SET a = 5; +INSERT INTO my_table VALUES (3, 'hi there'); </programlisting> This is a sequence of three commands, one per line (although this is not required; more than one command can be on a line, and @@ -146,11 +146,11 @@ INSERT INTO MY_TABLE VALUES (3, 'hi there'); </indexterm> Key words and unquoted identifiers are case insensitive. Therefore: <programlisting> -UPDATE MY_TABLE SET A = 5; +UPDATE my_table SET a = 5; </programlisting> can equivalently be written as: <programlisting> -uPDaTE my_TabLE SeT a = 5; +UPDATE my_table SET a = 5; </programlisting> A convention often used is to write key words in upper case and names in lower case, e.g.: |