diff options
| author | Bruce Momjian <bruce@momjian.us> | 2010-08-11 21:48:51 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2010-08-11 21:48:51 +0000 |
| commit | a4a3ef344e189d714d06224892e636c3153e8103 (patch) | |
| tree | 6e0b68331e1c8180ffa106ade1c8e806615450dc | |
| parent | c9ae257e232ab9256bdf867ab9da570c4ab6f10a (diff) | |
| download | postgresql-a4a3ef344e189d714d06224892e636c3153e8103.tar.gz postgresql-a4a3ef344e189d714d06224892e636c3153e8103.zip | |
Properly lowercase identifiers, uppercase keywords, in doc examples
| -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 ee2c5214aa9..d2d14dbe9fc 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.150 2010/08/05 18:21:17 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/syntax.sgml,v 1.151 2010/08/11 21:48:51 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.: |