Waiting for PostgreSQL 14 – Allow subscripting of hstore values.

On 11st of December 2020, Tom Lane committed patch: Allow subscripting of hstore values.   This is basically a finger exercise to prove that it’s possible for an extension module to add subscripting ability. Subscripted fetch from an hstore is not different from the existing "hstore -> text" operator. Subscripted update does seem to be … Continue reading “Waiting for PostgreSQL 14 – Allow subscripting of hstore values.”

Waiting for 8.5 – changes in hstore

Andrew Gierth (RhodiumToad on irc) wrote, and Tom Lane committed: Assorted improvements in contrib/hstore.   Remove the 64K limit on the lengths of keys and values within an hstore. (This changes the on-disk format, but the old format can still be read.) Add support for btree/hash opclasses for hstore — this is not so much … Continue reading “Waiting for 8.5 – changes in hstore”

hstore będzie w oficjalnych źródłach?

jakiś czas temu pisałem nt. hstore. w dużym skrócie – jest do moduł do postgresa pozwalający na przechowywanie w pojedynczym polu dowolnej ilości par klucz-wartość. i wyszukiwanie – oczywiście indeksowane. wtedy, jedyną możliwością zdobycia hstore’a było wyszukanie adresu strony twórców, ściągnięcie paczki i kompilacja. skomplikowane – zwłaszcza dlatego, że hstore wymaga kompilacji wewnątrz oryginalnych źródeł. … Continue reading “hstore będzie w oficjalnych źródłach?”

Waiting for 9.4 – Introduce jsonb, a structured format for storing json.

Portuguese Brazil Version On 23rd of March, Andrew Dunstan committed patch: Introduce jsonb, a structured format for storing json.   The new format accepts exactly the same data as the json type. However, it is stored in a format that does not require reparsing the orgiginal text in order to process it, making it much … Continue reading “Waiting for 9.4 – Introduce jsonb, a structured format for storing json.”

Waiting for 9.4 – New json functions.

On 28th of January, Andrew Dunstan committed patch: New json functions.   json_build_array() and json_build_object allow for the construction of arbitrarily complex json trees. json_object() turns a one or two dimensional array, or two separate arrays, into a json_object of name/value pairs, similarly to the hstore() function. json_object_agg() aggregates its two arguments into a single … Continue reading “Waiting for 9.4 – New json functions.”