From 8c19d14be57225d52f0cbdce48a9c7e26aa74a27 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Tue, 3 Aug 2010 15:15:31 +0000 Subject: [PATCH] Fix markup, other minor editing for recent btree_gist doc changes. --- doc/src/sgml/btree-gist.sgml | 26 +++++++++++++------------- 1 file changed, 13 insertions(+), 13 deletions(-) diff --git a/doc/src/sgml/btree-gist.sgml b/doc/src/sgml/btree-gist.sgml index d477f23a2e..9434318ed3 100644 --- a/doc/src/sgml/btree-gist.sgml +++ b/doc/src/sgml/btree-gist.sgml @@ -1,4 +1,4 @@ - + btree_gist @@ -29,10 +29,10 @@ In addition to the typical btree search operators, btree_gist also - provides search operators for <> ("not - equals"). This may be useful in combination with an - Exclusion Constraint, - as descibed below. + provides search operators for <> (not + equals). This may be useful in combination with an + exclusion constraint, + as described below. @@ -51,26 +51,26 @@ SELECT * FROM test WHERE a < 10; - Example using an Exclusion - Constraint to enforce the constraint that a cage at a zoo + Use an exclusion + constraint to enforce the rule that a cage at a zoo can contain only one kind of animal: -=> CREATE TABLE zoo ( +=> CREATE TABLE zoo ( cage INTEGER, animal TEXT, - EXCLUDE USING gist (cage WITH =, animal WITH <>) + EXCLUDE USING gist (cage WITH =, animal WITH <>) ); -=> INSERT INTO zoo VALUES(123, 'zebra'); +=> INSERT INTO zoo VALUES(123, 'zebra'); INSERT 0 1 -=> INSERT INTO zoo VALUES(123, 'zebra'); +=> INSERT INTO zoo VALUES(123, 'zebra'); INSERT 0 1 -=> INSERT INTO zoo VALUES(123, 'lion'); +=> INSERT INTO zoo VALUES(123, 'lion'); ERROR: conflicting key value violates exclusion constraint "zoo_cage_animal_excl" DETAIL: Key (cage, animal)=(123, lion) conflicts with existing key (cage, animal)=(123, zebra). -=> INSERT INTO zoo VALUES(124, 'lion'); +=> INSERT INTO zoo VALUES(124, 'lion'); INSERT 0 1 -- 2.40.0