On 26th of April, Peter Eisentraut committed patch: Add transforms feature This provides a mechanism for specifying conversions between SQL data types and procedural languages. As examples, there are transforms for hstore and ltree for PL/Perl and PL/Python. reviews by Pavel Stěhule and Andres ...

On 10th of March, Andrew Dunstan committed patch: JSON generation improvements. This adds the following: json_agg(anyrecord) -> json to_json(any) -> json hstore_to_json(hstore) -> json (also used as a cast) hstore_to_json_loose(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 ...

You might be familiar with hstore datatype in PostgreSQL - if you're not - check it out, as it is really cool. Basically it's hash in database, which you can search in.

November 2nd, 2007 by depesz | Tags: , | 5 comments »

in postgresql 8.2, in contrib, is great new datatype called hstore. if you're not familiar with it - check the docs. in short - this is indexable associative-array (hash) in one field. i was given a task to convert some text field to ...