diff options
Diffstat (limited to 'doc/src/sgml/ddl.sgml')
| -rw-r--r-- | doc/src/sgml/ddl.sgml | 30 |
1 files changed, 15 insertions, 15 deletions
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index 727b00f0eaf..4beacc7b82d 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.38 2005/01/17 01:29:02 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.38.4.1 2005/01/22 23:05:47 momjian Exp $ --> <chapter id="ddl"> <title>Data Definition</title> @@ -275,7 +275,7 @@ CREATE TABLE products ( CREATE TABLE products ( product_no integer, name text, - price numeric <emphasis>CHECK (price > 0)</emphasis> + price numeric <emphasis>CHECK (price > 0)</emphasis> ); </programlisting> </para> @@ -303,7 +303,7 @@ CREATE TABLE products ( CREATE TABLE products ( product_no integer, name text, - price numeric <emphasis>CONSTRAINT positive_price</emphasis> CHECK (price > 0) + price numeric <emphasis>CONSTRAINT positive_price</emphasis> CHECK (price > 0) ); </programlisting> So, to specify a named constraint, use the key word @@ -320,9 +320,9 @@ CREATE TABLE products ( CREATE TABLE products ( product_no integer, name text, - price numeric CHECK (price > 0), - discounted_price numeric CHECK (discounted_price > 0), - <emphasis>CHECK (price > discounted_price)</emphasis> + price numeric CHECK (price > 0), + discounted_price numeric CHECK (discounted_price > 0), + <emphasis>CHECK (price > discounted_price)</emphasis> ); </programlisting> </para> @@ -350,10 +350,10 @@ CREATE TABLE products ( product_no integer, name text, price numeric, - CHECK (price > 0), + CHECK (price > 0), discounted_price numeric, - CHECK (discounted_price > 0), - CHECK (price > discounted_price) + CHECK (discounted_price > 0), + CHECK (price > discounted_price) ); </programlisting> or even @@ -361,9 +361,9 @@ CREATE TABLE products ( CREATE TABLE products ( product_no integer, name text, - price numeric CHECK (price > 0), + price numeric CHECK (price > 0), discounted_price numeric, - CHECK (discounted_price > 0 AND price > discounted_price) + CHECK (discounted_price > 0 AND price > discounted_price) ); </programlisting> It's a matter of taste. @@ -377,10 +377,10 @@ CREATE TABLE products ( product_no integer, name text, price numeric, - CHECK (price > 0), + CHECK (price > 0), discounted_price numeric, - CHECK (discounted_price > 0), - <emphasis>CONSTRAINT valid_discount</> CHECK (price > discounted_price) + CHECK (discounted_price > 0), + <emphasis>CONSTRAINT valid_discount</> CHECK (price > discounted_price) ); </programlisting> </para> @@ -442,7 +442,7 @@ CREATE TABLE products ( CREATE TABLE products ( product_no integer NOT NULL, name text NOT NULL, - price numeric NOT NULL CHECK (price > 0) + price numeric NOT NULL CHECK (price > 0) ); </programlisting> The order doesn't matter. It does not necessarily determine in which |