You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Stable version, included into PostgreSQL distribution, released under BSD license. Development version, available from this site, released under the GNU General Public License, version 2 (June 1991).
14
+
LEGAL NOTICES: This module is released under BSD license (as PostgreSQL
* delete (hstore,text) - delete (key,value) from hstore if key matches argument.
98
+
* delete (hstore,text) - delete (key,value) from hstore if key matches
99
+
argument.
99
100
100
101
regression=# select delete('a=>1,b=>2','b');
101
102
delete
@@ -110,14 +111,16 @@ regression=# select * from each('a=>1,b=>2');
110
111
a | 1
111
112
b | 2
112
113
113
-
* isexists (hstore,text) - returns 'true if key is exists in hstore and false otherwise.
114
+
* isexists (hstore,text) - returns 'true if key is exists in hstore and
115
+
false otherwise.
114
116
115
117
regression=# select isexists('a=>1','a');
116
118
isexists
117
119
----------
118
120
t
119
121
120
-
* isdefined (hstore,text) - returns true if key is exists in hstore and its value is not NULL.
122
+
* isdefined (hstore,text) - returns true if key is exists in hstore and
123
+
its value is not NULL.
121
124
122
125
regression=# select isdefined('a=>NULL','a');
123
126
isdefined
@@ -148,7 +151,9 @@ update tt set h=delete(h,'k1');
148
151
149
152
* Statistics
150
153
151
-
hstore type, because of its intrinsic liberality, could contain a lot of different keys. Checking for valid keys is the task of application. Examples below demonstrate several techniques how to check keys statistics.
154
+
hstore type, because of its intrinsic liberality, could contain a lot of
155
+
different keys. Checking for valid keys is the task of application.
156
+
Examples below demonstrate several techniques how to check keys statistics.
152
157
153
158
o simple example
154
159
@@ -172,4 +177,4 @@ select key, count(*) from (select (each(h)).key from testhstore) as stat group b
0 commit comments