Skip site navigation (1) Skip section navigation (2)

hstore patch

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: hstore patch
Date: 2009-07-08 20:01:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
This patch is the updated-to-current-HEAD version of the hstore stuff
I did some months back. It is believed to be fully API-compatible with
the old hstore, though it has a different storage layout. Dump and
restore of an old db should work (the new module provides all the
function names the old one did), though the new functionality
obviously won't be available that way.

Short list of new functionality:

 - unlimited key/value length
 - binary I/O
 - btree and hash support
 - construction of hstores from key/value arrays
 - hstore(record) and populate_record(record,hstore) for dynamic
   manipulations of records
 - many operators for hstore difference, slices, etc.; very useful
   for determining changes

Andrew (irc:RhodiumToad)

Attachment: hstore_20090708.patch.gz
Description: text/x-patch (128.4 KB)

pgsql-hackers by date

Next:From: Mike RylanderDate: 2009-07-08 20:18:31
Subject: Fwd: tsvector extraction patch
Previous:From: Alvaro HerreraDate: 2009-07-08 19:38:15
Subject: Re: tsvector extraction patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group