|
hstore ( record ) → hstore
Constructs an hstore from a record or row.
hstore(ROW(1,2)) → "f1"=>"1", "f2"=>"2"
|
|
hstore ( text[] ) → hstore
Constructs an hstore from an array, which may be either a key/value array, or a two-dimensional array.
hstore(ARRAY['a','1','b','2']) → "a"=>"1", "b"=>"2"
hstore(ARRAY[['c','3'],['d','4']]) → "c"=>"3", "d"=>"4"
|
|
hstore ( text[], text[] ) → hstore
Constructs an hstore from separate key and value arrays.
hstore(ARRAY['a','b'], ARRAY['1','2']) → "a"=>"1", "b"=>"2"
|
|
hstore ( text, text ) → hstore
Makes a single-item hstore.
hstore('a', 'b') → "a"=>"b"
|
|
akeys ( hstore ) → text[]
Extracts an hstore's keys as an array.
akeys('a=>1,b=>2') → {a,b}
|
|
skeys ( hstore ) → setof text
Extracts an hstore's keys as a set.
skeys('a=>1,b=>2') →
a
b
|
|
avals ( hstore ) → text[]
Extracts an hstore's values as an array.
avals('a=>1,b=>2') → {1,2}
|
|
svals ( hstore ) → setof text
Extracts an hstore's values as a set.
svals('a=>1,b=>2') →
1
2
|
|
hstore_to_array ( hstore ) → text[]
Extracts an hstore's keys and values as an array of alternating keys and values.
hstore_to_array('a=>1,b=>2') → {a,1,b,2}
|
|
hstore_to_matrix ( hstore ) → text[]
Extracts an hstore's keys and values as a two-dimensional array.
hstore_to_matrix('a=>1,b=>2') → {{a,1},{b,2}}
|
|
hstore_to_json ( hstore ) → json
Converts an hstore to a json value, converting all non-null values to JSON strings.
This function is used implicitly when an hstore value is cast to json.
hstore_to_json('"a key"=>1, b=>t, c=>null, d=>12345, e=>012345, f=>1.234, g=>2.345e+4') → {"a key": "1", "b": "t", "c": null, "d": "12345", "e": "012345", "f": "1.234", "g": "2.345e+4"}
|
|
hstore_to_jsonb ( hstore ) → jsonb
Converts an hstore to a jsonb value, converting all non-null values to JSON strings.
This function is used implicitly when an hstore value is cast to jsonb.
hstore_to_jsonb('"a key"=>1, b=>t, c=>null, d=>12345, e=>012345, f=>1.234, g=>2.345e+4') → {"a key": "1", "b": "t", "c": null, "d": "12345", "e": "012345", "f": "1.234", "g": "2.345e+4"}
|
|
hstore_to_json_loose ( hstore ) → json
Converts an hstore to a json value, but attempts to distinguish numerical and Boolean values so they are unquoted in the JSON.
hstore_to_json_loose('"a key"=>1, b=>t, c=>null, d=>12345, e=>012345, f=>1.234, g=>2.345e+4') → {"a key": 1, "b": true, "c": null, "d": 12345, "e": "012345", "f": 1.234, "g": 2.345e+4}
|
|
hstore_to_jsonb_loose ( hstore ) → jsonb
Converts an hstore to a jsonb value, but attempts to distinguish numerical and Boolean values so they are unquoted in the JSON.
hstore_to_jsonb_loose('"a key"=>1, b=>t, c=>null, d=>12345, e=>012345, f=>1.234, g=>2.345e+4') → {"a key": 1, "b": true, "c": null, "d": 12345, "e": "012345", "f": 1.234, "g": 2.345e+4}
|
|
slice ( hstore, text[] ) → hstore
Extracts a subset of an hstore containing only the specified keys.
slice('a=>1,b=>2,c=>3'::hstore, ARRAY['b','c','x']) → "b"=>"2", "c"=>"3"
|
|
each ( hstore ) → setof record ( key text, value text )
Extracts an hstore's keys and values as a set of records.
select * from each('a=>1,b=>2') →
key | value
-----+-------
a | 1
b | 2
|
|
exist ( hstore, text ) → boolean
Does hstore contain key?
exist('a=>1', 'a') → t
|
|
defined ( hstore, text ) → boolean
Does hstore contain a non-NULL value for key?
defined('a=>NULL', 'a') → f
|
|
delete ( hstore, text ) → hstore
Deletes pair with matching key.
delete('a=>1,b=>2', 'b') → "a"=>"1"
|
|
delete ( hstore, text[] ) → hstore
Deletes pairs with matching keys.
delete('a=>1,b=>2,c=>3', ARRAY['a','b']) → "c"=>"3"
|
|
delete ( hstore, hstore ) → hstore
Deletes pairs matching those in the second argument.
delete('a=>1,b=>2', 'a=>4,b=>2'::hstore) → "a"=>"1"
|
|
populate_record ( anyelement, hstore ) → anyelement
Replaces fields in the left operand (which must be a composite type) with matching values from hstore.
populate_record(ROW(1,2), 'f1=>42'::hstore) → (42,2)
|