diff --git a/doc/src/sgml/hstore.sgml b/doc/src/sgml/hstore.sgml
index 08e0d7b..442dad5 100644
--- a/doc/src/sgml/hstore.sgml
+++ b/doc/src/sgml/hstore.sgml
@@ -203,7 +203,7 @@
%#> hstore>
convert hstore to 2-dimensional key/value array
- %% 'a=>foo, b=>bar'::hstore>
+ %# 'a=>foo, b=>bar'::hstore>
{{a,foo},{b,bar}}
@@ -407,6 +407,8 @@ CREATE INDEX hidx ON testhstore USING GIN (h);
CREATE INDEX hidx ON testhstore USING BTREE (h);
+
+CREATE INDEX hidx ON testhstore USING HASH (h);
@@ -474,13 +476,14 @@ SELECT (r).* FROM (SELECT t #= '"col3"=>"baz"' AS r FROM test t) s;
- This version of the module uses a different internal representation
- than previous versions. This presents no obstacle for dump/restore
- upgrades since the text representation (used in the dump) is unchanged.
+ As of PostgreSQL 8.5, hstore> uses a different internal
+ representation than previous versions. This presents no obstacle for
+ dump/restore upgrades since the text representation (used in the dump) is
+ unchanged.
- However, in the event of doing a binary upgrade, upward
+ In the event of doing a binary upgrade, upward
compatibility is maintained by having the new code recognize
old-format data. This will entail a slight performance penalty when
processing data that has not yet been modified by the new code. It is