Typos in CREATE TABLE doc
It seems to me there are typos in the reference page for CREATE TABLE.
Please find attached a patch.
Thanks,
Best regards,
Etsuro Fujita
Attachments:
createtable_typofix.patchtext/x-diff; name=createtable_typofix.patchDownload
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml
index 299cce8..ebcb885 100644
--- a/doc/src/sgml/ref/create_table.sgml
+++ b/doc/src/sgml/ref/create_table.sgml
@@ -422,8 +422,8 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI
The <literal>CHECK</> clause specifies an expression producing a
Boolean result which new or updated rows must satisfy for an
insert or update operation to succeed. Expressions evaluating
- to TRUE or UNKNOWN succeed. Should any row of an insert or
- update operation produce a FALSE result an error exception is
+ to TRUE or UNKNOWN succeed. If any row of an insert or
+ update operation produces a FALSE result, an error exception is
raised and the insert or update does not alter the database. A
check constraint specified as a column constraint should
reference that column's value only, while an expression
On 11/13/2014 12:45 PM, Etsuro Fujita wrote:
It seems to me there are typos in the reference page for CREATE TABLE.
The structure of the sentence is a bit funky, but it seems correct to
me. If you google for "should any", you'll get a bunch of pages
discussing similar sentences.
I would add a comma there, though: "Should any row of an insert or
update operation produce a FALSE result, an exception is raised and ..."
- Heikki
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
(2014/11/13 20:07), Heikki Linnakangas wrote:
On 11/13/2014 12:45 PM, Etsuro Fujita wrote:
It seems to me there are typos in the reference page for CREATE TABLE.
The structure of the sentence is a bit funky, but it seems correct to
me. If you google for "should any", you'll get a bunch of pages
discussing similar sentences.I would add a comma there, though: "Should any row of an insert or
update operation produce a FALSE result, an exception is raised and ..."
I understand. So, Here is the comma patch.
Thanks,
Best regards,
Etsuro Fujita
Attachments:
doc_add_comma.patchtext/x-diff; name=doc_add_comma.patchDownload
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml
index 299cce8..bc6db45 100644
--- a/doc/src/sgml/ref/create_table.sgml
+++ b/doc/src/sgml/ref/create_table.sgml
@@ -423,7 +423,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI
Boolean result which new or updated rows must satisfy for an
insert or update operation to succeed. Expressions evaluating
to TRUE or UNKNOWN succeed. Should any row of an insert or
- update operation produce a FALSE result an error exception is
+ update operation produce a FALSE result, an error exception is
raised and the insert or update does not alter the database. A
check constraint specified as a column constraint should
reference that column's value only, while an expression
On Thu, Nov 13, 2014 at 08:30:49PM +0900, Etsuro Fujita wrote:
(2014/11/13 20:07), Heikki Linnakangas wrote:
On 11/13/2014 12:45 PM, Etsuro Fujita wrote:
It seems to me there are typos in the reference page for CREATE TABLE.
The structure of the sentence is a bit funky, but it seems correct to
me. If you google for "should any", you'll get a bunch of pages
discussing similar sentences.I would add a comma there, though: "Should any row of an insert or
update operation produce a FALSE result, an exception is raised and ..."I understand. So, Here is the comma patch.
Patch applied.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On 2015/03/21 5:58, Bruce Momjian wrote:
On Thu, Nov 13, 2014 at 08:30:49PM +0900, Etsuro Fujita wrote:
(2014/11/13 20:07), Heikki Linnakangas wrote:
On 11/13/2014 12:45 PM, Etsuro Fujita wrote:
It seems to me there are typos in the reference page for CREATE TABLE.
The structure of the sentence is a bit funky, but it seems correct to
me. If you google for "should any", you'll get a bunch of pages
discussing similar sentences.I would add a comma there, though: "Should any row of an insert or
update operation produce a FALSE result, an exception is raised and ..."I understand. So, Here is the comma patch.
Patch applied.
Thanks!
Best regards,
Etsuro Fujita
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers