[DOCS] Confusing example context
Hi, I mentioned this before, but no-one responded to it. This page, http://www.postgresql.org/docs/9.0/static/sql-syntax-lexical.html, has some confusing text. It talks about the fact that comments can be included in SQL, then the next sentence says "For example.." followed by an example without comments in. I think the sentence is in the wrong place, so have moved it to a less confusing location in the attached patch. Thanks -- Thom Brown Registered Linux user: #516935 diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index 595314b..9f91939 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -47,12 +47,6 @@ special character is adjacent to some other token type). - - Additionally, comments can occur in SQL - input. They are not tokens, they are effectively equivalent to - whitespace. - - For example, the following is (syntactically) valid SQL input: @@ -66,6 +60,12 @@ INSERT INTO MY_TABLE VALUES (3, 'hi there'); + Additionally, comments can occur in SQL + input. They are not tokens, they are effectively equivalent to + whitespace. + + + The SQL syntax is not very consistent regarding what tokens identify commands and which are operands or parameters. The first few tokens are generally the command name, so in the above example -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
[DOCS] pgcrypto links
In looking for documentation of pgcrypto to respond to a user request for help, I noticed that we could have provided more links to help users find the docs for it. Attached is a docs patch which is intended to help with that. -Kevin *** a/doc/src/sgml/pgcrypto.sgml --- b/doc/src/sgml/pgcrypto.sgml *** *** 7,12 --- 7,17 pgcrypto + + encryption + for specific columns + + The pgcrypto module provides cryptographic functions for PostgreSQL. *** a/doc/src/sgml/runtime.sgml --- b/doc/src/sgml/runtime.sgml *** *** 1504,1510 $ kill -INT `head -1 /usr/local/pgsql/data/postmaster.pid` The contrib function library pgcrypto allows certain fields to be stored ! encrypted. This is useful if only some of the data is sensitive. The client supplies the decryption key and the data is decrypted on the server and then sent to the client. --- 1504,1511 The contrib function library pgcrypto allows certain fields to be stored ! encrypted. (See for details.) ! This is useful if only some of the data is sensitive. The client supplies the decryption key and the data is decrypted on the server and then sent to the client. -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] Confusing example context
On Thu, Aug 12, 2010 at 3:49 PM, Thom Brown wrote: > I mentioned this before, but no-one responded to it. This page, > http://www.postgresql.org/docs/9.0/static/sql-syntax-lexical.html, has > some confusing text. It talks about the fact that comments can be > included in SQL, then the next sentence says "For example.." followed > by an example without comments in. > > I think the sentence is in the wrong place, so have moved it to a less > confusing location in the attached patch. Committed. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
