diff options
| author | Robert Haas <rhaas@postgresql.org> | 2011-11-07 21:47:45 -0500 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2011-11-07 21:47:45 -0500 |
| commit | b60653bc0b75b7f3b5dda0a2968a22129aafb2b2 (patch) | |
| tree | 626bcd83e8c11629eb54fb1afec2226f15fbb2e4 /doc/src | |
| parent | bbb6e559c4ea0fb4c346beda76736451dc24eb4e (diff) | |
| download | postgresql-b60653bc0b75b7f3b5dda0a2968a22129aafb2b2.tar.gz postgresql-b60653bc0b75b7f3b5dda0a2968a22129aafb2b2.zip | |
Remove hstore's text => text operator.
Since PostgreSQL 9.0, we've emitted a warning message when an operator
named => is created, because the SQL standard now reserves that token
for another use. But we've also shipped such an operator with hstore.
Use of the function hstore(text, text) has been recommended in
preference to =>(text, text). Per discussion, it's now time to take
the next step and stop shipping the operator. This will allow us to
prohibit the use of => as an operator name in a future release if and
when we wish to support the SQL standard use of this token.
The release notes should mention this incompatibility.
Patch by me, reviewed by David Wheeler, Dimitri Fontaine and Tom Lane.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/hstore.sgml | 17 |
1 files changed, 1 insertions, 16 deletions
diff --git a/doc/src/sgml/hstore.sgml b/doc/src/sgml/hstore.sgml index aa212952657..a03f926f0b7 100644 --- a/doc/src/sgml/hstore.sgml +++ b/doc/src/sgml/hstore.sgml @@ -120,13 +120,6 @@ key => NULL </row> <row> - <entry><type>text</> <literal>=></> <type>text</></entry> - <entry>make single-pair <type>hstore</></entry> - <entry><literal>'a' => 'b'</literal></entry> - <entry><literal>"a"=>"b"</literal></entry> - </row> - - <row> <entry><type>hstore</> <literal>||</> <type>hstore</></entry> <entry>concatenate <type>hstore</>s</entry> <entry><literal>'a=>b, c=>d'::hstore || 'c=>x, d=>q'::hstore</literal></entry> @@ -224,14 +217,6 @@ key => NULL </para> </note> - <note> - <para> - The <literal>=></> operator is deprecated and may be removed in a - future release. Use the <literal>hstore(text, text)</literal> function - instead. - </para> - </note> - <table id="hstore-func-table"> <title><type>hstore</> Functions</title> @@ -455,7 +440,7 @@ CREATE INDEX hidx ON testhstore USING HASH (h); <para> Add a key, or update an existing key with a new value: <programlisting> -UPDATE tab SET h = h || ('c' => '3'); +UPDATE tab SET h = h || hstore('c', '3'); </programlisting> </para> |