postgres.git / summary / log / commit / refs

commit    b12ca1d56136db61d141ad160236b9f745bb354f
Author:   Robert Haas <rhaas@postgresql.org>
Date:     Tue Jun 22 11:36:44 2010 +0000
First released in: 9.0.0, 8.2.18, 8.3.12, 8.4.5

    Deprecate the use of => as an operator name.
    
    In HEAD, emit a warning when an operator named => is defined.
    In both HEAD and the backbranches (except in 8.2, where contrib
    modules do not have documentation), document that hstore's text =>
    text operator may be removed in a future release, and encourage the
    use of the hstore(text, text) function instead.  This function only
    exists in HEAD (previously, it was called tconvert), so backpatch
    it back to 8.2, when hstore was added.  Per discussion.


 contrib/hstore/hstore.sql.in        | 6 ++++++
 contrib/hstore/uninstall_hstore.sql | 1 +
 2 files changed, 7 insertions(+)

diff --git a/contrib/hstore/hstore.sql.in b/contrib/hstore/hstore.sql.in
index 95cecf15d29..4e7c494694b 100644
--- a/contrib/hstore/hstore.sql.in
+++ b/contrib/hstore/hstore.sql.in
@@ -118,6 +118,12 @@ RETURNS hstore
 AS 'MODULE_PATHNAME'
 LANGUAGE 'C' with (isstrict,iscachable);
 
+-- For forward compatibility with PostgreSQL >= 9.0
+CREATE OR REPLACE FUNCTION hstore(text,text)
+RETURNS hstore
+AS 'MODULE_PATHNAME', 'tconvert'
+LANGUAGE C IMMUTABLE; -- not STRICT
+
 CREATE OPERATOR => (
 	LEFTARG = text,
 	RIGHTARG = text,
diff --git a/contrib/hstore/uninstall_hstore.sql b/contrib/hstore/uninstall_hstore.sql
index bfa2e738dce..f0b9fa5e7be 100644
--- a/contrib/hstore/uninstall_hstore.sql
+++ b/contrib/hstore/uninstall_hstore.sql
@@ -21,6 +21,7 @@ DROP FUNCTION hs_concat(hstore,hstore);
 DROP FUNCTION hs_contains(hstore,hstore);
 DROP FUNCTION hs_contained(hstore,hstore);
 DROP FUNCTION tconvert(text,text);
+DROP FUNCTION hstore(text,text);
 DROP FUNCTION akeys(hstore);
 DROP FUNCTION avals(hstore);
 DROP FUNCTION skeys(hstore);


[parent: 0a557605f2e9]