| 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) |
|
|